How do I create a cell formula to achieve this?

[Don]

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

 

[sheetallakhotia]

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))

 

[John]

Hi Don
Try this
=IF(AND(A9="",B9=""),"ZZZ",IF(AND(A9>0,B9>0),B9,IF(AND(A9>0,B9=""),"ZZZ")))
You can change the range to your choice.
HTH
John

 

[Don]

Thanks much! That worked just great!
--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))

 

[Don]

Thanks, John!
--Don

Hi Don
Try this
=IF(AND(A9="",B9=""),"ZZZ",IF(AND(A9>0,B9>0),B9,IF(AND(A9>0,B9=""),"ZZZ")))
You can change the range to your choice.
HTH
John