| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function within a cell that has a number
I have a number in a1 which is 500. Is there a way I can leave the 500 in
place, along with add a formula to that cell as well. I want to add a1+b1, but I want to keep the 500 there. I know alt + enter goes down to the next line, but when I insert the formula it doesnt work. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell value as a row number in a function? | Excel Worksheet Functions | |||
| function to count the number of cell references in a formula | Excel Worksheet Functions | |||
| Setting Cell Number Format With A Worksheet Function | Excel Worksheet Functions | |||
| Which function can be used to Read the number in a cell ? | Excel Worksheet Functions | |||
| #VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Threaded Mode
