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 figure
this out - I would appreciate all help. - Thank you.


--
jmv
------------------------------------------------------------------------
jmv's Profile: http://www.excelforum.com/member.php...o&userid=35609
View this thread: http://www.excelforum.com/showthread...hreadid=553804

=IF(AND(OR(A10,A20,),A3=0),"footnote a","")

"jmv" wrote:


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 figure
this out - I would appreciate all help. - Thank you.


--
jmv
------------------------------------------------------------------------
jmv's Profile: http://www.excelforum.com/member.php...o&userid=35609
View this thread: http://www.excelforum.com/showthread...hreadid=553804

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

=IF(AND(OR(A10,A20),A3=0),"Footnote A","")

=IF(OR(A10,AND(A20,A3=0)),"Footnote A","")

HTH,
Elkar


"jmv" wrote:


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 figure
this out - I would appreciate all help. - Thank you.


--
jmv
------------------------------------------------------------------------
jmv's Profile: http://www.excelforum.com/member.php...o&userid=35609
View this thread: http://www.excelforum.com/showthread...hreadid=553804

Hi JMV

Try

=if(if(or(a10,a20),and(a3=0)),"footnote A","")

hope this helps
regards from Brazil
Marcelo

"jmv" escreveu:


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 figure
this out - I would appreciate all help. - Thank you.


--
jmv
------------------------------------------------------------------------
jmv's Profile: http://www.excelforum.com/member.php...o&userid=35609
View this thread: http://www.excelforum.com/showthread...hreadid=553804

let me try to restate this

if either a1 is greater than zero or a2 is greater than zero and a3 is
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!


--
jmv
------------------------------------------------------------------------
jmv's Profile: http://www.excelforum.com/member.php...o&userid=35609
View this thread: http://www.excelforum.com/showthread...hreadid=553804

HTH

=IF(AND(A3=0,OR(A10,A20)),"","footnote A")


--
Bearacade


------------------------------------------------------------------------
Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
View this thread: http://www.excelforum.com/showthread...hreadid=553804