View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Newbeetle Newbeetle is offline
external usenet poster
 
Posts: 98
Default 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