Is the IF formula the best for this?

[RichLeeson]

Is the IF formula the best for this?

i work for a Vending machine reseller and currently have to size up the items to put in the machine as they have different drawers they could go in.

For example, an A drawer has the capacity to take a product 97mm wide, and 23mm high, with depths ranging from 26 to 366mm. i have tried doing this with IF formula, but to no avail.

=IF(I70>300, "T8", IF(I70>200, "T6", (I70>175, "T4", (I70>120, "4", (I70>70, "3", (I70>23 "2", (I70>0 "1", "FALSE")))))))

this formula works, but the next formula i have to work takes over 7 stages, so it wont work.

i will attach further details.

Example of products:

Height Width Length
30 80 130
23 23 65
23 23 65
23 23 65
23 23 65
23 23 65
23 23 65

Drawer sizes are:

Level Width Height
Z 1 63 23
A 1 97 23
AA 1 250 23
B 2 97 68
BB 1 250 68
C 1 164 23
D 2 164 70
E 1 385 23
F 2 385 68
G 3 397 120
H 4 397 175
J 4 160 175
T4 4 440 200
T6 6 440 300
T8 8 440 400

Please help, as this will save me hours per week.

Many thanks

[NBVC]

Hello,

It was mentioned to you before that your title does not meet our forum rules.

Please don't start new threads, amend the title.

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.