Cell Values

  • Thread starter Thread starter GaryW
  • Start date Start date
G

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!!!
 
If A1 contains nothing zero is returned, if A1 has a value cell value in C1
is returned

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