how make formulate results in text?
 

I need know how make formulate with a cell have a condition and results in text
e. if b3 < 6 then "s" or something like that

how make formulate results in text?
 

Yakko

In C3 or any cell but B3 enter =IF(B3<6,"s","not<6")


Gord Dibben MS Excel MVP

On Thu, 15 Feb 2007 13:01:03 -0800, Yakko
wrote:

I need know how make formulate with a cell have a condition and results in text
e. if b3 < 6 then "s" or something like that

how make formulate results in text?
 

=IF(AND(B3<6,B3<""),"s","")

This would return "S" if B3 is lower than 6 and not blank.
Otherwise it leaves the cell balnk.
--
This post was created using recycled electrons!


"Yakko" wrote:

I need know how make formulate with a cell have a condition and results in text
e. if b3 < 6 then "s" or something like that