Apr 23 2018 11:06 AM
I have another tricky Excel IF-Then formula that I need but I can’t figure out how to search for a solution online without knowing the correct terms to use.
What I’m trying to do is generate a result based off of 4 multiple options
Result =1 for an item selling for $0-12.49
Result =2 for an item selling between $12.50-14.99
Result =3 for an item selling between $15.00-17.49
Result =4 for an item selling $17.50 and up
Thanks for any help you can provide.
Apr 23 2018 04:46 PM
If I read your question correctly, you could probably solve the problem with a nested if statement something like this:
(assuming your value is in cell A1)
=if(A1<12.5,1, if(A1<15,2,if(a1<17.5,3,4)))
Cheers