How do I create a cell formula to achieve this?
 

How do I create the following to determine the value of Cell C?

IF Cell A = blank then Cell C = "ZZZ"
IF Cell A = non-blank and Cell B = non-blank, then Cell C = Cell B
IF Cell A = non-blank and Cell B = blank, then Cell C = "ZZZ"

Thanks,
Don

How do I create a cell formula to achieve this?
 

On Oct 16, 4:01*am, Don wrote:
How do I create the following to determine the value of Cell C?

* * * *IF Cell A = blank then Cell C = "ZZZ"
* * * *IF Cell A = non-blank and Cell B = non-blank, then Cell C = Cell B
* * * *IF Cell A = non-blank and Cell B = blank, then Cell C = "ZZZ"

Thanks,
Don

Try using this formula given below...paste it in cell C...

For the sake of simplicity, I have used A1,B1,C1....

=IF(ISBLANK(A1),"ZZZ",IF(ISBLANK(B1),"ZZZ",B1))

How do I create a cell formula to achieve this?
 

Hi Don
Try this
=IF(AND(A9="",B9=""),"ZZZ",IF(AND(A90,B90),B9,IF (AND(A90,B9=""),"ZZZ")))
You can change the range to your choice.
HTH
John
"Don" wrote in message
...
How do I create the following to determine the value of Cell C?

IF Cell A = blank then Cell C = "ZZZ"
IF Cell A = non-blank and Cell B = non-blank, then Cell C = Cell B
IF Cell A = non-blank and Cell B = blank, then Cell C = "ZZZ"

Thanks,
Don

How do I create a cell formula to achieve this?
 

Thanks much! That worked just great!
--Don


On Thu, 15 Oct 2009 16:41:39 -0700 (PDT), " wrote:

On Oct 16, 4:01*am, Don wrote:
How do I create the following to determine the value of Cell C?

* * * *IF Cell A = blank then Cell C = "ZZZ"
* * * *IF Cell A = non-blank and Cell B = non-blank, then Cell C = Cell B
* * * *IF Cell A = non-blank and Cell B = blank, then Cell C = "ZZZ"

Thanks,
Don

Try using this formula given below...paste it in cell C...

For the sake of simplicity, I have used A1,B1,C1....

=IF(ISBLANK(A1),"ZZZ",IF(ISBLANK(B1),"ZZZ",B1))

How do I create a cell formula to achieve this?
 

Thanks, John!
--Don


On Thu, 15 Oct 2009 19:45:15 -0400, "John" wrote:

Hi Don
Try this
=IF(AND(A9="",B9=""),"ZZZ",IF(AND(A90,B90),B9,IF (AND(A90,B9=""),"ZZZ")))
You can change the range to your choice.
HTH
John
"Don" wrote in message
.. .
How do I create the following to determine the value of Cell C?

IF Cell A = blank then Cell C = "ZZZ"
IF Cell A = non-blank and Cell B = non-blank, then Cell C = Cell B
IF Cell A = non-blank and Cell B = blank, then Cell C = "ZZZ"

Thanks,
Don

How do I create a cell formula to achieve this?
 

=IF(OR(A1="",B1=""),"ZZZ","whatever your other answer is")
or
=IF(AND(A1<"",B1<""),"whatever your other answer is","ZZZ")
--
David Biddulph

Don wrote:
How do I create the following to determine the value of Cell C?

IF Cell A = blank then Cell C = "ZZZ"
IF Cell A = non-blank and Cell B = non-blank, then Cell C =
Cell B IF Cell A = non-blank and Cell B = blank, then Cell C =
"ZZZ"

Thanks,
Don