| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Empty cell return a value from another cell
Re-phrase quesiton.
I want to put a formula in a cell to look at a cell and if it is blank I want to return the value from another cell if not blank return nothing. Cell A1 is blank, I want to put a formula in cell c1 that will look in B1 and return to A1 the value of B1. Else do nothing. -- Thanks for your help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Empty cell return a value from another cell
A formula in cell C1 will not write a value to cell A1. It can write a
value to C1, but not to anywhere else. [And please continue with the previous thread, rather than starting a new one.] -- David Biddulph "hilltop55" wrote in message ... Re-phrase quesiton. I want to put a formula in a cell to look at a cell and if it is blank I want to return the value from another cell if not blank return nothing. Cell A1 is blank, I want to put a formula in cell c1 that will look in B1 and return to A1 the value of B1. Else do nothing. -- Thanks for your help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sumproduct issues | Excel Worksheet Functions | |||
| modifying this formula to return an empty cell | Excel Discussion (Misc queries) | |||
| insert date | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Linear Mode
