# Formula for several "If/Then" support

✭✭

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!

Tags:

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭

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

• ✭✭✭✭✭✭

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!