=IF(AND(a10, a2=0), TRUE, FALSE)

and statements are in format
=and(criteria1, criteria2)
ifs are in format
=if(criteria, then, else)



wrote:
I am a newbie and I have a simple IF statement I would like to do but I
am not sure how to write it. If cell A1 is greater than 0 and cell A2
equals 0 then I want it to tell me True or False but I am not sure how
to write this, can someone help out?
Thanks,
Mike Francis

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200603/1