I have 3 entries generated by if statements in 3 cells next to each other. D1, E1, F1. Based on the IF statement outcomes, only one of these cells will show a value. For instance, D1 will show "FALSE", E1 will show 5899 and F1 will show "FALSE". Depending on the IF statements, next time D1 may show the value and E1 this time showing "FALSE". Here is the problem: I need to know which cell is showing the value this time, so that I can show that value in another cell. But I don't know how to construct the new IF statement to check which one of the three cells contain a value, and then show me that value! Any ideas would be welcomed. Thanks so long.

Change your original formulas to say Else 0 so that the results in D1, E1 and F1 have a value. Then in your other cell use =IF(D1>0,D1,IF(E1>0,E1,IF(F1>0,F1,0))) or supply some more specific information about the values of the cells and how they are derived. Not really enough to work with right now. Bryan