If...and... - can never get the syntax correct!

Howdie

Spreadsheet 1 columns and 2 rows.
In A2, either a yes or no
In A3 either a yes or no
I need to put in A4 formulae that will tell me:
If a2 = a3 are equal,put "okay".
If a2 = No, and a3 = yes, Put "problem"
If a2 = Yes and a3 = No, put "okay"

Thanks so much

D



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Hi Darin

=IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem","not
sure"))

Cheers
JulieD


"Darin Kramer" <darin_kramer@hotmail.com> wrote in message
news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
>
>
> Howdie
>
> Spreadsheet 1 columns and 2 rows.
> In A2, either a yes or no
> In A3 either a yes or no
> I need to put in A4 formulae that will tell me:
> If a2 = a3 are equal,put "okay".
> If a2 = No, and a3 = yes, Put "problem"
> If a2 = Yes and a3 = No, put "okay"
>
> Thanks so much
>
> D
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!

=IF(OR(A2=A3,A2="Yes"),"Okay","Problem")


"Darin Kramer" wrote:

>
>
> Howdie
>
> Spreadsheet 1 columns and 2 rows.
> In A2, either a yes or no
> In A3 either a yes or no
> I need to put in A4 formulae that will tell me:
> If a2 = a3 are equal,put "okay".
> If a2 = No, and a3 = yes, Put "problem"
> If a2 = Yes and a3 = No, put "okay"
>
> Thanks so much
>
> D
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>

Hi Julie,

The not sure condition can never be met as stated by OP, you just need

=IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay","problem")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:uy8JwKIMFHA.3328@TK2MSFTNGP14.phx.gbl...
> Hi Darin
>
>
=IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem
","not
> sure"))
>
> Cheers
> JulieD
>
>
> "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
> news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
> >
> >
> > Howdie
> >
> > Spreadsheet 1 columns and 2 rows.
> > In A2, either a yes or no
> > In A3 either a yes or no
> > I need to put in A4 formulae that will tell me:
> > If a2 = a3 are equal,put "okay".
> > If a2 = No, and a3 = yes, Put "problem"
> > If a2 = Yes and a3 = No, put "okay"
> >
> > Thanks so much
> >
> > D
> >
> >
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>
>

I don't think it needs to be that complex, as long as A2 and A3 MUST contain
either "Yes" or "No". If A2="Yes" it doesn't matter what's in A3.

"JulieD" wrote:

> Hi Darin
>
> =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem","not
> sure"))
>
> Cheers
> JulieD
>
>
> "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
> news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
> >
> >
> > Howdie
> >
> > Spreadsheet 1 columns and 2 rows.
> > In A2, either a yes or no
> > In A3 either a yes or no
> > I need to put in A4 formulae that will tell me:
> > If a2 = a3 are equal,put "okay".
> > If a2 = No, and a3 = yes, Put "problem"
> > If a2 = Yes and a3 = No, put "okay"
> >
> > Thanks so much
> >
> > D
> >
> >
> >
> > *** Sent via Developersdex http://www.developersdex.com ***
> > Don't just participate in USENET...get rewarded for it!
>
>
>

or even

=IF(OR(A2=A3,A2="Yes),"okay","problem")


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OXNRkXIMFHA.1308@TK2MSFTNGP15.phx.gbl...
> Hi Julie,
>
> The not sure condition can never be met as stated by OP, you just need
>
> =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay","problem")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> news:uy8JwKIMFHA.3328@TK2MSFTNGP14.phx.gbl...
> > Hi Darin
> >
> >
>
=IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem
> ","not
> > sure"))
> >
> > Cheers
> > JulieD
> >
> >
> > "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
> > news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
> > >
> > >
> > > Howdie
> > >
> > > Spreadsheet 1 columns and 2 rows.
> > > In A2, either a yes or no
> > > In A3 either a yes or no
> > > I need to put in A4 formulae that will tell me:
> > > If a2 = a3 are equal,put "okay".
> > > If a2 = No, and a3 = yes, Put "problem"
> > > If a2 = Yes and a3 = No, put "okay"
> > >
> > > Thanks so much
> > >
> > > D
> > >
> > >
> > >
> > > *** Sent via Developersdex http://www.developersdex.com ***
> > > Don't just participate in USENET...get rewarded for it!
> >
> >
>
>

Now you got it!

"Bob Phillips" wrote:

> or even
>
> =IF(OR(A2=A3,A2="Yes),"okay","problem")
>
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
> news:OXNRkXIMFHA.1308@TK2MSFTNGP15.phx.gbl...
> > Hi Julie,
> >
> > The not sure condition can never be met as stated by OP, you just need
> >
> > =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay","problem")
> >
> > --
> >
> > HTH
> >
> > RP
> > (remove nothere from the email address if mailing direct)
> >
> >
> > "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> > news:uy8JwKIMFHA.3328@TK2MSFTNGP14.phx.gbl...
> > > Hi Darin
> > >
> > >
> >
> =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem
> > ","not
> > > sure"))
> > >
> > > Cheers
> > > JulieD
> > >
> > >
> > > "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
> > > news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
> > > >
> > > >
> > > > Howdie
> > > >
> > > > Spreadsheet 1 columns and 2 rows.
> > > > In A2, either a yes or no
> > > > In A3 either a yes or no
> > > > I need to put in A4 formulae that will tell me:
> > > > If a2 = a3 are equal,put "okay".
> > > > If a2 = No, and a3 = yes, Put "problem"
> > > > If a2 = Yes and a3 = No, put "okay"
> > > >
> > > > Thanks so much
> > > >
> > > > D
> > > >
> > > >
> > > >
> > > > *** Sent via Developersdex http://www.developersdex.com ***
> > > > Don't just participate in USENET...get rewarded for it!
> > >
> > >
> >
> >
>
>
>

if one of A2 or A3 DOESN'T contain either Yes or No and the one other does,
you get a false result .... can we "assume" that both will be filled with
only these values? - maybe the OPs cells to check at BA23 and AL1245 ... and
they want to know the result in A1.

anyway, the OP can choose which one to use


"Charlie" <Charlie@discussions.microsoft.com> wrote in message
news:4D6A6A0A-474A-4187-863F-F7D9A4E33A82@microsoft.com...
>I don't think it needs to be that complex, as long as A2 and A3 MUST
>contain
> either "Yes" or "No". If A2="Yes" it doesn't matter what's in A3.
>
> "JulieD" wrote:
>
>> Hi Darin
>>
>> =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem","not
>> sure"))
>>
>> Cheers
>> JulieD
>>
>>
>> "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
>> news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
>> >
>> >
>> > Howdie
>> >
>> > Spreadsheet 1 columns and 2 rows.
>> > In A2, either a yes or no
>> > In A3 either a yes or no
>> > I need to put in A4 formulae that will tell me:
>> > If a2 = a3 are equal,put "okay".
>> > If a2 = No, and a3 = yes, Put "problem"
>> > If a2 = Yes and a3 = No, put "okay"
>> >
>> > Thanks so much
>> >
>> > D
>> >
>> >
>> >
>> > *** Sent via Developersdex http://www.developersdex.com ***
>> > Don't just participate in USENET...get rewarded for it!
>>
>>
>>

Hi Bob

the "not sure" condition can be met under the following circumstances
AND(A2="No", A3="")
AND(A2="No",A3="Yes ")
AND(A2=" ",A3="No")

etc .... as we don't know the "real" range that the OP is going to apply the
solution to i thought it prudent to check that they only get the requested
result when the data matches what they asked for.

anyway the OP can decide which formula to use

Cheers
JulieD

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:OXNRkXIMFHA.1308@TK2MSFTNGP15.phx.gbl...
> Hi Julie,
>
> The not sure condition can never be met as stated by OP, you just need
>
> =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay","problem")
>
> --
>
> HTH
>
> RP
> (remove nothere from the email address if mailing direct)
>
>
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> news:uy8JwKIMFHA.3328@TK2MSFTNGP14.phx.gbl...
>> Hi Darin
>>
>>
> =IF(OR(A2=A3,AND(A2="Yes",A3="No")),"okay",IF(AND(A2="No",A3="Yes"),"problem
> ","not
>> sure"))
>>
>> Cheers
>> JulieD
>>
>>
>> "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
>> news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
>> >
>> >
>> > Howdie
>> >
>> > Spreadsheet 1 columns and 2 rows.
>> > In A2, either a yes or no
>> > In A3 either a yes or no
>> > I need to put in A4 formulae that will tell me:
>> > If a2 = a3 are equal,put "okay".
>> > If a2 = No, and a3 = yes, Put "problem"
>> > If a2 = Yes and a3 = No, put "okay"
>> >
>> > Thanks so much
>> >
>> > D
>> >
>> >
>> >
>> > *** Sent via Developersdex http://www.developersdex.com ***
>> > Don't just participate in USENET...get rewarded for it!
>>
>>
>
>

Thanks all for your input,thought and ultimately the perfect solution!
It works!



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

can we "assume"...?

"JulieD" wrote:

> ... can we "assume" that both will be filled with
> only these values? ...

In this case, yes.

> >>
> >> "Darin Kramer" <darin_kramer@hotmail.com> wrote in message
> >> news:eSb$GHIMFHA.2680@TK2MSFTNGP09.phx.gbl...
> >> >
> >> > In A2, either a yes or no
> >> > In A3 either a yes or no

Hi Judie,


"JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
news:eRMdsoIMFHA.3336@TK2MSFTNGP10.phx.gbl...

> the "not sure" condition can be met under the following circumstances
> AND(A2="No", A3="")
> AND(A2="No",A3="Yes ")
> AND(A2=" ",A3="No")

as I said, as stated by the OP ...

In A2, either a yes or no
In A3 either a yes or no

> anyway the OP can decide which formula to use

Well, he has few choices :-)

Spell checker got me Julie, no offence :-)

Regards

Bod


"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:u9MzdyIMFHA.2748@TK2MSFTNGP09.phx.gbl...
> Hi Judie,
>
>
> "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
> news:eRMdsoIMFHA.3336@TK2MSFTNGP10.phx.gbl...
>
> > the "not sure" condition can be met under the following circumstances
> > AND(A2="No", A3="")
> > AND(A2="No",A3="Yes ")
> > AND(A2=" ",A3="No")
>
> as I said, as stated by the OP ...
>
> In A2, either a yes or no
> In A3 either a yes or no
>
> > anyway the OP can decide which formula to use
>
> Well, he has few choices :-)
>
>