Hi - this is my first time posting.

I'm automating a worksheet for analyzing raw data from biology experiments. I can do most of the automating - it's pretty simple Excel formulas. But there are two steps that I'm having a bit of trouble with. I think I could accomplish what I need with a whole bunch of nested IF-THEN-ELSE commands, but I'm hoping there is a simpler way to do it.

The attached Excel file has actual data from one of our experiments. I put a yellow background color on the cells that are relevant to my question. At the bottom of the table of data, I wrote descriptions of the logic that is required. I hope the descriptions are clear. I think/hope Excel has formulas that will provide a simple solution to what I'm trying to achieve.

I'm using Excel 14.2.5 on a Mac. The worksheet must work on both Mac and Windows machines. I'm hoping to do this without using VBA.

Thanks in advance for any suggestions.

I'm automating a worksheet for analyzing raw data from biology experiments. I can do most of the automating - it's pretty simple Excel formulas. But there are two steps that I'm having a bit of trouble with. I think I could accomplish what I need with a whole bunch of nested IF-THEN-ELSE commands, but I'm hoping there is a simpler way to do it.

The attached Excel file has actual data from one of our experiments. I put a yellow background color on the cells that are relevant to my question. At the bottom of the table of data, I wrote descriptions of the logic that is required. I hope the descriptions are clear. I think/hope Excel has formulas that will provide a simple solution to what I'm trying to achieve.

I'm using Excel 14.2.5 on a Mac. The worksheet must work on both Mac and Windows machines. I'm hoping to do this without using VBA.

Thanks in advance for any suggestions.