IF Formula

hjm · Jul 2, 2007

Hiya,

I need a formula for the following:

If P2 & T2 both = 0 then Yes otherwise No

Thanks

HJM

Roger Govier · Jul 2, 2007

Hi

=IF(AND(P2=0,T2=0),"yes","no")

Pete_UK · Jul 2, 2007

Try this:

=IF(AND(P2=0,T2=0),"Yes","No")

Hope this helps.

Pete

bj · Jul 2, 2007

if(and(P2=0,T2=0),"Yes","No")

CmK · Jul 2, 2007

Hi
try this
=IF(AND(P2=0,T2=0),"yes","no")

thanks

hjm · Jul 2, 2007

Thanks everyone, that worked a treat

bj said:
if(and(P2=0,T2=0),"Yes","No")