View Single Post
  #4   Report Post  
JulieD
 
Posts: n/a
Default

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.