software

=IF(AND(a1gt;0, a2=0), TRUE, FALSE)

and statements are in format
=and(criteria1, criteria2)
ifs are in format
=if(criteria, then, else)wrote:
gt;I am a newbie and I have a simple IF statement I would like to do but I
gt;am not sure how to write it. If cell A1 is greater than 0 and cell A2
gt;equals 0 then I want it to tell me True or False but I am not sure how
gt;to write this, can someone help out?
gt;Thanks,
gt;Mike Francis

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


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(a1gt;0,a2=0)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=525875