Hi and welcome to MrExcel.
If I understand you and your IF logic correctly, does this work for you?....
Sample data and example results....
Sheet13
* | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | AE |
1 | * | Results | * | Data1 | * | * | * | Data2 | * | * | Data3 | * | * | * | * | * | Data4 | * | * | * | * | * | * | * | * | * | * | * | Data5 | * |
2 | * | 100 | * | 1000 | * | * | * | 600 | * | * | 150 | * | * | * | * | * | 08/04/2013 | * | * | * | * | * | * | * | * | * | * | * | 100 | * |
3 | * | 2000 | * | 2000 | * | * | * | 0 | * | * | 0 | * | * | * | * | * | 0 | * | * | * | * | * | * | * | * | * | * | * | 0 | * |
4 | * | 300 | * | 3000 | * | * | * | 400 | * | * | 350 | * | * | * | * | * | 09/04/2013 | * | * | * | * | * | * | * | * | * | * | * | 300 | * |
5 | * | 450 | * | 4000 | * | * | * | 300 | * | * | 450 | * | * | * | * | * | 0 | * | * | * | * | * | * | * | * | * | * | * | 400 | * |
6 | * | 550 | * | 5000 | * | * | * | 200 | * | * | 550 | * | * | * | * | * | 0 | * | * | * | * | * | * | * | * | * | * | * | 0 | * |
7 | * | 600 | * | 6000 | * | * | * | 100 | * | * | 650 | * | * | * | * | * | 10/04/2013 | * | * | * | * | * | * | * | * | * | * | * | 600 | * |
8 | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * | * |
<COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 30px"><COL style="WIDTH: 64px"><COL style="WIDTH: 11px"><COL style="WIDTH: 64px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 64px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 64px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 75px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 10px"><COL style="WIDTH: 64px"><COL style="WIDTH: 29px"></COLGROUP><TBODY>
</TBODY>
Spreadsheet Formulas |
Cell | Formula | C2 | =IF(AND(R2<>0,ISNUMBER(R2)),AD2,IF(AND(R2=0,MAX(I2,L2,AD2)=0),E2,MAX(I2,L2,AD2))) |
<TBODY>
</TBODY> |
<TBODY>
</TBODY>
Excel tables to the web >> Excel Jeanie HTML 4
The formula in C2 needs to be copied down, you can put this formula in any cell you want.
I hope that helps.
Ak