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 (e-mail address removed)

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula, sum the value cell and if empty cell left blank 0
If function across sheets prints value of cell 4
Excel VBA 1
Lookup returning wrong results 0
Select a range not equal to: 4
Excel Need Countifs Formula Help 0
Vlookup and return sheet name also 2
Compare 1 cell to column of cells returning adjacent cells info? 1

Top