Home |
Search |
Today's Posts |
#1
|
|||
|
|||
IF statement w/ more than 7 arguments needed
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If Then statement help needed | Excel Worksheet Functions | |||
If Statement help needed please | Excel Worksheet Functions | |||
If statement help needed please | Excel Discussion (Misc queries) | |||
If statement help needed | Excel Worksheet Functions | |||
If statement needed | Excel Worksheet Functions |