If/And/Or formula

J

jmv

I need a formula for the below:

if a1 is greater than zero or a2 is greater than zero and a3 is zero
then "footnote A"

I have been trying If formulas with And and I can not seem to figur
this out - I would appreciate all help. - Thank you
 
E

Elkar

There are a couple ways to read your question, but one of these formulas
should do the trick:

=IF(AND(OR(A1>0,A2>0),A3=0),"Footnote A","")

=IF(OR(A1>0,AND(A2>0,A3=0)),"Footnote A","")

HTH,
Elkar
 
M

Marcelo

Hi JMV

Try

=if(if(or(a1>0,a2>0),and(a3=0)),"footnote A","")

hope this helps
regards from Brazil
Marcelo

"jmv" escreveu:
 
J

jmv

let me try to restate this

if either a1 is greater than zero or a2 is greater than zero and a3 i
zero - then "footnote A"

a1 a2 a3 a4
1 1 0 footnote a
1 0 1 blank
1 1 4 blank
0 1 0 footnote a

Thank you once again for all your help
 
Top