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

  • Thread starter Thread starter DaleWid
  • Start date Start date
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 (e-mail address removed)

thanks
 
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
 
Back
Top