ExcelBanter - IF Formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - IF Formula (https://www.excelbanter.com/excel-discussion-misc-queries/148670-if-formula.html)

hjm

IF Formula

Hiya,

I need a formula for the following:

If P2 & T2 both = 0 then Yes otherwise No

Thanks

HJM

Roger Govier

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

Pete_UK

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

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

CmK

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

hjm

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

All times are GMT +1. The time now is 08:49 PM.