IF Function #VALUE Error

[Reddazrael]

Okay, I am stumped (hence why I'm posting here). No matter what I do, I cannot get this formula to work. Here is the current bane of my existence:

=IF(J7 < 25%, "Text 1"), IF(J7>25%, "Text 2"), IF(J7>50%, "Text 3"), IF(J7>75%, "Text 4"), IF(J7>= 99%,"Text 5")
​

I have no idea what I'm doing wrong. I've even put spaces around the < sign, as I saw being suggested in another posted, but no dice. If someone could help me, that would be greatly appreciated.

 

[Joe4]

Welcome to the Board!

A few things:
- When nesting IF statements, do NOT close off the brackets with a right-bracket until the end, or else you are ending the whole formula.
- When working through a series of different levels, start either at the top or bottom and work your way up or down.
It is important to note that once a TRUE condition is met, it stops there. So you do not want to test if J7>25% before J7>50%, as any number greater than 50% will also be greater than 25%, so it will NEVER get to your 50% check.

Try this:

=IF(J7>=99%,"Text 5",IF(J7>75%,"Text 4",IF(J7>50%,"Text 3",IF(J7>25%,"Text 2","Text 1"))))

 

[Reddazrael]

Welcome to the Board!

A few things:
- When nesting IF statements, do NOT close off the brackets with a right-bracket until the end, or else you are ending the whole formula.
- When working through a series of different levels, start either at the top or bottom and work your way up or down.
It is important to note that once a TRUE condition is met, it stops there. So you do not want to test if J7>25% before J7>50%, as any number greater than 50% will also be greater than 25%, so it will NEVER get to your 50% check.

Try this:

=IF(J7>=99%,"Text 5",IF(J7>75%,"Text 4",IF(J7>50%,"Text 3",IF(J7>25%,"Text 2","Text 1"))))

Thank you so much. As you can probably tell, I'm only just starting to learn Excel, so your advice is really appreciated! The formula is now doing what I want it to do, so you've made me a very happy individual. Thank you again!

 

[Joe4]

You are welcome.
Glad to help, and hope the logic/methodology makes sense!