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