Change text in a cell depending on the value of another (1 Viewer)

Groundrush

Registered User.
Local time
Today, 12:39
Joined
Apr 14, 2002
Messages
1,376
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

"Doctor Access"
Local time
Today, 07:39
Joined
May 20, 2009
Messages
1,932
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

Registered User.
Local time
Today, 12:39
Joined
Apr 14, 2002
Messages
1,376
Thank you, does exactly what I was looking for :)
 

Users who are viewing this thread

Top Bottom