Formula to return 'TBA' if cell contains text 'TBA'
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?
Answers

@Genevieve P. are you able to help? 🙂

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
Categories
Check out the Formula Handbook template!