# Formula to return 'TBA' if cell contains text 'TBA'

Options
✭✭

Hi,

I'm currently using this formula which works:

=IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun"))))

However, I would like to add that if the cell contains 'TBA', then the value will return 'TBA' instead of 'Under Budget', 'On Budget'...etc. How can I do that?

• ✭✭
Options

@Genevieve P. are you able to help? 🙂

• ✭✭✭✭✭✭
edited 03/16/22
Options

Hi @Ann11,

Try this :

`=IF(CONTAINS("TBA", [\[H\] Variance (%)]@row), "TBA", IF([\[H\] Variance (%)]@row < 0, "Under Budget", IF([\[H\] Variance (%)]@row = 0, "On Budget", IF(AND([\[H\] Variance (%)]@row > 0, [\[H\] Variance (%)]@row < 0.15), "Moderate Budget Overrun", IF([\[H\] Variance (%)]@row > 0.15, "Significant Budget Overrun")))))`

Hope it works.

Gia Thinh Technology Co., LTD - Smartsheet Solution Partner.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!