Easy IF Function
 

=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

Easy IF Function
 

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(a10,a2=0)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=525875