If condition with text
in [General]
|
Prev: Formula to breakdown original amount with two components to th
Next: how do i stop excel from converting numbers entered into a date
From: ART on 6 May 2010 09:56 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. I'm very new at Excel, I hope someone can help! Thanks,
From: Don Guillett on 6 May 2010 10:02 =IF(LEFT(O2,6)="Coping",1, if(LEFT(O2,5)="Paver",0,"")) -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett(a)gmail.com "ART" <ART(a)discussions.microsoft.com> wrote in message news:8E8662A4-8A06-4DCA-A8E8-4B23102CF0A3(a)microsoft.com... >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. > > I'm very new at Excel, I hope someone can help! Thanks, >
From: Luke M on 6 May 2010 10:34 In addition to Don's post about the first formula, the 2nd formula sounds like it is a type of data validation formula. In which case, select B1, and goto Data - Validation. Choose custom, and formula is: =OR(A1<>1,B1>0) -- Best Regards, Luke M "Don Guillett" <dguillett1(a)gmail.com> wrote in message news:OcWe5SS7KHA.4208(a)TK2MSFTNGP06.phx.gbl... > =IF(LEFT(O2,6)="Coping",1, if(LEFT(O2,5)="Paver",0,"")) > > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "ART" <ART(a)discussions.microsoft.com> wrote in message > news:8E8662A4-8A06-4DCA-A8E8-4B23102CF0A3(a)microsoft.com... >>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. >> >> I'm very new at Excel, I hope someone can help! Thanks, >> >
From: ART on 6 May 2010 10:43
Thank you! That worked great. Any idea on how to get the second formula? I need a condition that says: If Cell "x " equals 0 then Cell y most be greater than 1 and it Cell "y" equals 1 then do nothing. Please help! "Don Guillett" wrote: > =IF(LEFT(O2,6)="Coping",1, if(LEFT(O2,5)="Paver",0,"")) > > > -- > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguillett(a)gmail.com > "ART" <ART(a)discussions.microsoft.com> wrote in message > news:8E8662A4-8A06-4DCA-A8E8-4B23102CF0A3(a)microsoft.com... > >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. > > > > I'm very new at Excel, I hope someone can help! Thanks, > > > > . > |