Hi,
First post here as i'm stumped. Love the forum...Need to find the position in a table a value is in between, then multiply that value by the price adjacent to that position in the table. Complicated by having 3 tables, apples oranges and peaches. An order of 3 Lb of Apples should total $4.5 (G4). An order 10 Lb order of peaches should price at $13 (G4), but using the below does not redirect to correct position in the correct table.
=IF(AND(G2=B25,G3>=A20),G3*C4,IF(AND(G2=B26,G3>=A20,G3<=B20),C9*G3,IF(AND(G2=B27,G3>=A20,G3<=B20),G3*C14)))
I have 12 values in each apples, oranges and peaches in actuality so a nested if would be very complicated and likely run into the limit allowed quickly...there's got to be a better way.
Thanks for your feedback!
Bookmarks