Forum Discussion
MS Excel - IF then with conditions
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 re...
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