Formula for several "If/Then" support

Sarah R

Hello Community! I have tried googling this for excel and I'm just not getting my formula to calculate what I want/need. I've created formula for equating a number range to a letter, but I can’t figure out how to get the letter cell to not populate if nothing is entered for a numerical value (left blank). I don't want to put "zero" because that equates to a letter group.  

My formula to get the Value 1 column to calculate the Letter Group 1:

=IF([Value 1]@row > 89.9, "A", IF([Value 1]@row > 79.9, "B", IF([Value 1]@row > 69.9, "C", IF([Value 1]@row > 59.9, "D", IF([Value 1]@row <= 59.9, "F")))))

... but I need to address the fact that the Value 1 may not have a value score and therefore not part of a Letter group which needs to be blank. (Hopefully this makes sense!) Any formula guru out there that can help? Thx!

Andrée Starå

Hi @Sarah R

I hope you're well and safe!

Try something like this.

=IF([Value 1]@row="","",IF([Value 1]@row > 89.9, "A", IF([Value 1]@row > 79.9, "B", 
IF([Value 1]@row > 69.9, "C", IF([Value 1]@row > 59.9, "D", IF([Value 1]@row <= 59.9, "F")

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Sarah R

YES! THANK YOU! I should have come here hours ago! ;-) Many many thanks.

Andrée Starå

@Sarah R

Excellent!

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!