Morning,

Just a quick one, how do I constuct the below...

A1 A2
0% 0%

I need a formula in A3 that will say "YES" if A1 and A2 =0%.

Many thanks,
James.

Hi
This depends on whether your cell is formatted as a percentage or text. Try:
=IF(A1=A2=0,"YES","")
or
=IF(A1=A2="0%","YES","")

Hope this helps.
Andy.

"Jamesy" wrote in message
...
Morning,

Just a quick one, how do I constuct the below...

A1 A2
0% 0%

I need a formula in A3 that will say "YES" if A1 and A2 =0%.

Many thanks,
James.

That doesn't work!! I wonder why? Anyway, try these instead:
=IF(AND(A1=0,A2=0),"YES","")
or
=IF(AND(A1="0%",A2="0%"),"YES","")

Andy.

<Andy wrote in message ...
Hi
This depends on whether your cell is formatted as a percentage or text.
Try:
=IF(A1=A2=0,"YES","")
or
=IF(A1=A2="0%","YES","")

Hope this helps.
Andy.

"Jamesy" wrote in message
...
Morning,

Just a quick one, how do I constuct the below...

A1 A2
0% 0%

I need a formula in A3 that will say "YES" if A1 and A2 =0%.

Many thanks,
James.

<Andy wrote in message ...
That doesn't work!! I wonder why?

=IF(A1=A2=0,"YES","")

I don't know if this is true - perhaps someone who knows about the inner
workings of Excel will be able to tell us - but perhaps XL is reading it
as:

=IF(A1=(A2=0),"YES","")

which would be the equivalent to:

=IF(0=TRUE,"YES","")

Therefore the FALSE argument is returned.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


<Andy wrote in message ...
That doesn't work!! I wonder why? Anyway, try these instead:
=IF(AND(A1=0,A2=0),"YES","")
or
=IF(AND(A1="0%",A2="0%"),"YES","")

Andy.

<Andy wrote in message ...
Hi
This depends on whether your cell is formatted as a percentage or text.
Try:
=IF(A1=A2=0,"YES","")
or
=IF(A1=A2="0%","YES","")

Hope this helps.
Andy.

"Jamesy" wrote in message
...
Morning,

Just a quick one, how do I constuct the below...

A1 A2
0% 0%

I need a formula in A3 that will say "YES" if A1 and A2 =0%.

Many thanks,
James.

Thinking about it again, (post first think afterwards <g).....

I think that it is more likely that XL is interpreting it as:

=IF((A1=A2)=0,"YES","")

which of course would be:

=IF(TRUE=0,"YES","")

--

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Sandy Mann" wrote in message
...
<Andy wrote in message ...
That doesn't work!! I wonder why?

=IF(A1=A2=0,"YES","")

I don't know if this is true - perhaps someone who knows about the inner
workings of Excel will be able to tell us - but perhaps XL is reading it
as:

=IF(A1=(A2=0),"YES","")

which would be the equivalent to:

=IF(0=TRUE,"YES","")

Therefore the FALSE argument is returned.

--
Regards,

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


<Andy wrote in message ...
That doesn't work!! I wonder why? Anyway, try these instead:
=IF(AND(A1=0,A2=0),"YES","")
or
=IF(AND(A1="0%",A2="0%"),"YES","")

Andy.

<Andy wrote in message ...
Hi
This depends on whether your cell is formatted as a percentage or text.
Try:
=IF(A1=A2=0,"YES","")
or
=IF(A1=A2="0%","YES","")

Hope this helps.
Andy.

"Jamesy" wrote in message
...
Morning,

Just a quick one, how do I constuct the below...

A1 A2
0% 0%

I need a formula in A3 that will say "YES" if A1 and A2 =0%.

Many thanks,
James.

Personal i would use an AND() formula, ie:

=IF(AND(A1=0%,A2=0%),"Yes","")

thanks
Chris


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=551774

Superb guys, helpful as always.

"chalky" wrote:


Personal i would use an AND() formula, ie:

=IF(AND(A1=0%,A2=0%),"Yes","")

thanks
Chris


--
chalky
------------------------------------------------------------------------
chalky's Profile: http://www.excelforum.com/member.php...o&userid=23758
View this thread: http://www.excelforum.com/showthread...hreadid=551774