Yes/No Formula Help
 

I am wanting to create a formula to where if 0 is in A1 B1 will say yes and
if there is anything else in A1, B1 would say No. Note: If there is no 0 in
a 1 it will be because someone typed text in it.

Thank you
Jeremy

Yes/No Formula Help
 

Hi,
if(and(A1=0,B1=0),"Yes","No")

"Jeremy" wrote:

I am wanting to create a formula to where if 0 is in A1 B1 will say yes and
if there is anything else in A1, B1 would say No. Note: If there is no 0 in
a 1 it will be because someone typed text in it.

Thank you
Jeremy

Yes/No Formula Help
 

JEremy,

It depends on how you want to handle blanks:

=IF(AND(A1<"",A1=0),"Yes","No")
or
=IF(A1="","", IF(A1=0,"Yes","No"))
or
=IF(A1=0,"Yes","No")

HTH,
Bernie
MS Excel MVP


"Jeremy" wrote in message
...
I am wanting to create a formula to where if 0 is in A1 B1 will say yes and
if there is anything else in A1, B1 would say No. Note: If there is no 0 in
a 1 it will be because someone typed text in it.

Thank you
Jeremy

Yes/No Formula Help
 

In B1
=IF(AND(A1<"",A1=0),"Yes","No")


If this post helps click Yes
---------------
Jacob Skaria


"Jeremy" wrote:

I am wanting to create a formula to where if 0 is in A1 B1 will say yes and
if there is anything else in A1, B1 would say No. Note: If there is no 0 in
a 1 it will be because someone typed text in it.

Thank you
Jeremy

Yes/No Formula Help
 

Is this what I type in B1 and do I put a = in front of it?

Thank you for all of your help

"Eduardo" wrote:

Hi,
if(and(A1=0,B1=0),"Yes","No")

"Jeremy" wrote:

I am wanting to create a formula to where if 0 is in A1 B1 will say yes and
if there is anything else in A1, B1 would say No. Note: If there is no 0 in
a 1 it will be because someone typed text in it.

Thank you
Jeremy

Yes/No Formula Help
 

Got it thank you all for your help

"Jeremy" wrote:

Is this what I type in B1 and do I put a = in front of it?

Thank you for all of your help

"Eduardo" wrote:

Hi,
if(and(A1=0,B1=0),"Yes","No")

"Jeremy" wrote:

I am wanting to create a formula to where if 0 is in A1 B1 will say yes and
if there is anything else in A1, B1 would say No. Note: If there is no 0 in
a 1 it will be because someone typed text in it.

Thank you
Jeremy