I am having the IF function evaluate a row of numbers for the last cell
populated with a number greater than 0 (zero). When found it is performing a
calculation based on the number entered in to the last cell of the row
populated.

=IF(J410,J41-(I5*J5),IF(I410,I41-(I5*J5),IF(H410,H41-(I5*J5),IF(G410,G41-(I5*J5),IF(F410,F41-(I5*J5),IF(E410,E41-(i5*j5)....

I must evalaute cells p41..b41 for the last cell populated 0, and basis for
the calculation. I think I hit the max on nested arguments. I read that
Lookup is and option, but just do not get it. Or, can I work somehow around
the 7 argument limit. Thanks for your insight. Let me know if you need to
know more for recommendation purposes. Tom




--
Sony Luvy