ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   IF value in a cell, return another cell's value to original cell (https://www.excelbanter.com/excel-worksheet-functions/228852-if-value-cell-return-another-cells-value-original-cell.html)

DaleWid

IF value in a cell, return another cell's value to original cell
 
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

thanks

Sheeloo

IF value in a cell, return another cell's value to original cell
 
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

"DaleWid" wrote:

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

thanks



All times are GMT +1. The time now is 05:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com