how make formulate results in text?

Y

Yakko

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
 
G

Gord Dibben

Yakko

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


Gord Dibben MS Excel MVP
 
N

Newbeetle

=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.
 
Top