IF / AND Error

[Logit]

.
I am trying to use multiple IF / AND in a formula. Having searched the NET I don't find anything (yet) that shows how and I don't see anything that says it can't be done. ??

Here is the start of my goal:

=IF(AND(C5<26%,C5>24%),"25%",""),IF(AND(C5<51%,C5>49%),"50%","")

The final goal is to check C5 for 25%, 50%, 75% and 100%.

Because the percentage will never be exactly a whole number, it needs to check for < and > to narrow down a percentage range.



Can I use multiple IF / AND statements in the formula ? If yes, how ? If no, what approach is required ?


Formula Guru's ??

[AliGW]

This approach:

=IF(AND(C5<26%,C5>24%),"25%",IF(AND(C5<51%,C5>49%),"50%",IF(AND(C5<?%,C5>?%),"75%",AND(C5<?%,C5>?%),"100%",""))))

[63falcondude]

You can use AND with IF.

Something like this:

=IF(AND(C5<0.26,C5>0.24),0.25,IF(AND(C5<0.51,C5>0.49),0.50,...

That being said, I would use MROUND:

=MROUND(C5,0.25)

Edit: I withdraw the MROUND suggestion. That would round a value even if it is outside of the range that you want to check.

[Logit]

.
Thank you all for responding so quickly ! Wonderful resources !!!!

Ali ... edited your formula at end to this :

=IF(AND(C5<26%,C5>24%),"25%",IF(AND(C5<51%,C5>49%),"50%",IF(AND(C5<76%,C5>74%),"75%",IF(AND(C5=100%),"100%",""))))

Had to use that last "IF / AND" for it to work correctly.

Thank you all so much again.

[63falcondude]

Just for the fun of it, here's another option:

=IF(ABS(MROUND(C5,0.25)-C5)<0.01,MROUND(C5,0.25),"")

[AliGW]

Glad to have helped. The formula I gave was not intended to be the final formula, it was just showing you how to build yours. Happy you got there!