| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to formulate this??? | Excel Discussion (Misc queries) | |||
| need to formulate text from one worksheet to another in workbook | Excel Discussion (Misc queries) | |||
| time formulate | Excel Discussion (Misc queries) | |||
| HOW DO I FORMULATE A CELL TO ROUND $5.82 TO $5.85 | Excel Discussion (Misc queries) | |||
| How to make a formula display results only if value is greater tha | Excel Discussion (Misc queries) | |||
Linear Mode
