Change text in a cell depending on the value of another

[Groundrush]

Anyone know how to change the text in a cell depending on the value of another?

If the cell has a negative value then the text will read "Over Recovery"

Need to to then change to "Under Recovery" when the value changes to a positive value.


Thanks

 

[Mr. B]

This formula will check the value in B2 pub the text you what in the cell where the formula is located:

=IF(B2<0,"Under Recorery","Over Recovery")

Using this formula, zero will still put "Over Recovery" in the formula cell.

 

[Groundrush]

Thank you, does exactly what I was looking for