Easy IF Function

M

mdfranci

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
 
P

pau1a via OfficeKB.com

=IF(AND(a1>0, a2=0), TRUE, FALSE)

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

daddylonglegs

You don't really need to specify the TRUE and FALSE here as these are
the default outcomes of any conditional statement so this is
sufficient

=AND(a1>0,a2=0)
 
Top