IF value in a cell, return another cell's value to original cell

D

DaleWid

Is it possible to do this. IF 0 value in a cell, I want to (from another
cell) return another's cell to the original cell with a 0 value. Please
email me [email protected]

thanks
 
S

Sheeloo

You can NOT use a formula to change the value in the cell containing that
formula...
If A1 has a 0 then you can use this in B1
=IF(A1<>0,C1,"")
to get the value in C1 when A1 changes to any number from 0
 
Top