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