Need Formula Help

K

Kelly

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
 
F

Frank Kabel

Hi
normally I would use VLOOKUP for this. But I'm still not sure how your
spreadsheet is designed. You may post some example data (e.g. data for
row 9), describe each cell and define your expected result. This would
be much easier to generate a formula for you :)
 

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

Function for a nested if statement 2
Quick help with a simple function! 4
Multiple value if function using dates 2
Function Error 4
Concatenate and empty cell 4
ayuda con formula excel 1
An easier way? 9
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1

Top