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

Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
External cell reference between two excel worksheets both in One Drive 0
Adding cells until they are greater than a lookup cell and returning a value 1
Copy addition formula of non-consecutive horizontal cells 2
Excel does not accept text format! 0
Excel 2013: How to ensure a cell is not left blank by users? (Not using VBA) 0
If function across sheets prints value of cell 4

Top