Simple, but I can't get it.

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

Diane

Hello. I need help with this, it's 2 cells telling 1 cell what to do
is what I can get.

I have 3 cells I'm working with A1 A2 A3
cell A1 needs to display a YES or a NO depending on what cells A2 & A3
has in them.
If cell A2 has the number 1 and cell A3 is blank then I need cell A1
to display "YES"
If Cell A3 has the number 1 and cell A2 is blank then I need cell A1
to display "NO"

Hope I explane this correct. I can work with Excle but I can't get
this, please help me
Diane
 
=IF(AND(A2=1,ISBLANK(A3)),"Yes", IF(AND(A3=1,ISBLANK(A2)),"No", "Neither"))
best wishes
 
Thanks so much Bernard.
I would have never got this.
Very nice helping us like you do.
Enjoy your day
Diane (Di)
 
Diane said:
Hi
Tried that but didn't work. Anything I did wrong?
Thanks Di
Click to expand...

Works for me on Excel 2003. Are you sure that the cells in question are
a1,a2, and a3? Maybe you really wanted a1, b1, and c1 ? Just a thought..
 
Check your other post, too.
Hello. I need help with this, it's 2 cells telling 1 cell what to do
is what I can get.

I have 3 cells I'm working with A1 A2 A3
cell A1 needs to display a YES or a NO depending on what cells A2 & A3
has in them.
If cell A2 has the number 1 and cell A3 is blank then I need cell A1
to display "YES"
If Cell A3 has the number 1 and cell A2 is blank then I need cell A1
to display "NO"

Hope I explane this correct. I can work with Excle but I can't get
this, please help me
Diane
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

3 cell problem 3
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 1
Blank Cells 3
Data Validation and drop-down list using IF, AND and what else? 8
Finding the Percentage % in 2 Numbers 2
Excel =SUM(A1=A1+B1) 0
Formula in Excel 07 to get the formula used in one cell in anothercell, showing VALUES, not cells re 2
Building closed workbook file path within an Index Function 6

Back
Top