| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If condition with text
I need a formula for the following condition:
If text equals (word) then enter 1, if text equal (word 2) then enter 0 This is the formula I tried to used but is not working =IF(OR(LEFT(O2,6)="Coping",LEFT(O2,5)="Paver",O2=" "),0,1) Then I need another formula that works with the one above for the following condition: If (Cell A) equals 1 then ( cell B) must be greater than ( 0) and if ( Cell A ) equals 0 then nothing happens. Im very new at Excel, I hope someone can help! Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sum if (text meets condition) | Excel Discussion (Misc queries) | |||
| list text from a cell if condition met | Excel Discussion (Misc queries) | |||
| list text from a cell if condition met | Excel Discussion (Misc queries) | |||
| can you use a text colour as a formating condition? | Excel Discussion (Misc queries) | |||
| remove characters from a text under a condition | Excel Discussion (Misc queries) | |||
Threaded Mode
