| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Formula
Hiya,
I need a formula for the following: If P2 & T2 both = 0 then Yes otherwise No Thanks HJM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
Hi
=IF(AND(P2=0,T2=0),"yes","no") -- Regards Roger Govier "hjm" wrote in message ... Hiya, I need a formula for the following: If P2 & T2 both = 0 then Yes otherwise No Thanks HJM |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
Try this:
=IF(AND(P2=0,T2=0),"Yes","No") Hope this helps. Pete On Jul 2, 12:52 pm, hjm wrote: Hiya, I need a formula for the following: If P2 & T2 both = 0 then Yes otherwise No Thanks HJM |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
if(and(P2=0,T2=0),"Yes","No")
"hjm" wrote: Hiya, I need a formula for the following: If P2 & T2 both = 0 then Yes otherwise No Thanks HJM |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
Thanks everyone, that worked a treat :-)
"bj" wrote: if(and(P2=0,T2=0),"Yes","No") "hjm" wrote: Hiya, I need a formula for the following: If P2 & T2 both = 0 then Yes otherwise No Thanks HJM |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Formula
Hi
try this =IF(AND(P2=0,T2=0),"yes","no") thanks "hjm" wrote: Hiya, I need a formula for the following: If P2 & T2 both = 0 then Yes otherwise No Thanks HJM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
