Function for a nested if statement

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
 
R

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

Look at VLOOKUP or HLOOKUP


--ron
 
F

Frank Kabel

Hi
see your replies in Excel.misc

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple value if function using dates 2
IF, OR and SUM function 3
Need Formula Help 1
Quick help with a simple function! 4
Function Error 4
Help Nested If and And 2
If Function ignoring rest of formula 1
How do I create a YTD table which compares production for 4 facil. 0

Top