3 cell problem

  • Thread starter Thread starter Diane
  • Start date Start date
D

Diane

Hi need help with this simple task.
3 cells A1 A2 & A3,
if cell a2 has the number 1 in it I need cell A1 to display yes,
if cell a3 has the number 1 in it I need cell A1 to display no,
If both cells are blank I need A1 to be blank.

Thanks Much...
Diane
 
maybe...

=if(a2=1,"yes",if(a3=1,"no",if(and(a2="",a3=""),"","what goes here")))

What happens if both a2 and a3 contain 1?

What happens if A2 or A3 are not blank, but don't contain 1?
 
Hi & Thanks
When both cells A2 & A3 are blank A1 stays blank.
Only 1 cell A2 or A3 will have the number 1 in it.
Thanks dave
 
Thanks Dave, worked great...
Diane "Di"

maybe...

=if(a2=1,"yes",if(a3=1,"no",if(and(a2="",a3=""),"","what goes here")))

What happens if both a2 and a3 contain 1?

What happens if A2 or A3 are not blank, but don't contain 1?
Click to expand...
 
Back
Top