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

Ann11

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?

Ann11

@Genevieve P. are you able to help? 🙂

Gia Thinh

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.