How do I create a cell formula to achieve this?

  • Thread starter Thread starter Don
  • Start date Start date
D

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
 
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
Click to expand...

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))
 
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
 
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))
Click to expand...
 
Back
Top