Function for a nested if statement

[kmcnelson]

Is there a function I could use to replace this monster:
IF(K9>0,IF(O9>=K9,L9,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
(O9>=E9,F9,D9)))),IF(I9>0,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
(O9>=E9,F9,D9))),IF(G9>0,IF(O9>=G9,H9,IF(O9>=E9,F9,D9)),IF
(E9>0,IF(O9>=E9,F9,D9),D9))))
I'm trying to say "look at order size and match up with
lot size and return price".
TIA

 

[Ron Rosenfeld]

Is there a function I could use to replace this monster:
IF(K9>0,IF(O9>=K9,L9,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
(O9>=E9,F9,D9)))),IF(I9>0,IF(O9>=I9,J9,IF(O9>=G9,H9,IF
(O9>=E9,F9,D9))),IF(G9>0,IF(O9>=G9,H9,IF(O9>=E9,F9,D9)),IF
(E9>0,IF(O9>=E9,F9,D9),D9))))
I'm trying to say "look at order size and match up with
lot size and return price".
TIA

Look at VLOOKUP or HLOOKUP


--ron

 

[Frank Kabel]

Hi
see your replies in Excel.misc

P.S.: please don't multipost as this scatters your answers