if then statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you very much JulieD, this was a lot quicker then me trying to figure
it out!~MMM
 
Hi

that's the great thing about these ngs :)

glad it worked

Cheers
JulieD
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF Statement 3
countifs Function not giving desired result with date criteria 2
Subtracting time 5
Copying formulas across columns 2
More Planned and Actual Cycle Times 5
Today() and IF Function 6
Purpose of Double Unary in AND Statement 10
Text from excel address 1

Back
Top