| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
