Cell Values

[GaryW]

I would like to return the value of another cell(C1) if a
cell has a value in it, otherwise I want it to return a
value of 0. Example: IF(A1="any value",C1,0) This formula
would be written in B1. "Any value" would be numbers or
text.

Thanks 4 your help!!!

 

[Mark Graesser]

Try:

=IF(A1<>"",C1,0)

or

=IF(ISBLANK(A1),0,C1)

Good Luck,
Mark Graesser

 

[JS]

If A1 contains nothing zero is returned, if A1 has a value cell value in C1
is returned

=IF(ISBLANK(A1),0,C1)