MS Excel - IF then with conditions

Highlighted
Visitor

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.

1 Reply
Highlighted

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