if then statement
 

I am trying to write a "logical" function for the following: If there is a
"C" in A2, then there should be data in either b2 OR c2. Any help is
appreciated.

Hi

how about
=IF(A2="C",IF(OR(B2<"",C2""),True,false),false)

Cheers
JulieD


"MMM" wrote in message
...
I am trying to write a "logical" function for the following: If there is a
"C" in A2, then there should be data in either b2 OR c2. Any help is
appreciated.

Thank you very much JulieD, this was a lot quicker then me trying to figure
it out!~MMM

"JulieD" wrote:

Hi

how about
=IF(A2="C",IF(OR(B2<"",C2""),True,false),false)

Cheers
JulieD


"MMM" wrote in message
...
I am trying to write a "logical" function for the following: If there is a
"C" in A2, then there should be data in either b2 OR c2. Any help is
appreciated.

Hi

that's the great thing about these ngs :)

glad it worked

Cheers
JulieD


"MMM" wrote in message
...
Thank you very much JulieD, this was a lot quicker then me trying to
figure
it out!~MMM

"JulieD" wrote:

Hi

how about
=IF(A2="C",IF(OR(B2<"",C2""),True,false),false)

Cheers
JulieD


"MMM" wrote in message
...
I am trying to write a "logical" function for the following: If there is
a
"C" in A2, then there should be data in either b2 OR c2. Any help is
appreciated.