| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE | Excel Worksheet Functions | |||
| Lookup part of a cell's contents and return value of entire cell | Excel Discussion (Misc queries) | |||
| cell highlighted # from original cell | Excel Worksheet Functions | |||
| How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
| Why will solver only return the original adjustable cell values? | Excel Worksheet Functions | |||
Linear Mode
