=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