how make formulate results in text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Yakko

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


Gord Dibben MS Excel MVP
 
=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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TEXT issues 2
Clearing formulations 2
A text to appear on a mandatory cell 3
Count if criteria extracts from 2 cells both with formulas 2
Help: Using CONCATENATE (and a COUNT?) for a total result 3
DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS 5
how to formulate this??? 4
Very simple function not working 3

Back
Top