View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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