Function for a nested if statement

  • Thread starter Thread starter kmcnelson
  • Start date Start date
K

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
 
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
Click to expand...

Look at VLOOKUP or HLOOKUP


--ron
 
Hi
see your replies in Excel.misc

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