| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
covert only cell references in selected cells into value leaving the existingcell formula
How can I covert only cell references in selected cells into value
leaving the existingcell formula.e.g If A1=10 & A2=20 D1=30 & D2=40 A3= A1+A2 D3= D1+D2 I would like to have this A3 = 10+20 D3=30+40 Thxs |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Leaving a formula cell blank when data has not yet been added. | Excel Discussion (Misc queries) | |||
| Convert selected formula references from relative to absolute | Excel Discussion (Misc queries) | |||
| Copying a formula while leaving one cell fixed | Excel Discussion (Misc queries) | |||
| Leaving a total sum cell blank until other cells are filled | Excel Worksheet Functions | |||
| Copy cells to neighbor column after leaving the cell | Excel Worksheet Functions | |||
Threaded Mode
