| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
changing value in a cell
If a user enters a value say 12 in cell A1 and in cell B2 a formula =A1/4
is set up and the result would be 3. How would you go about it if in some cases the user can change the value in B2 to whatever say 6. As soom as the 6 was typed in B2 it would wipe out the formula. We would need the ablity to maintain the orginal formula in B2 the next time A1 is changed. Thanks and have a fun day. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell height changing when using autofill | Excel Discussion (Misc queries) | |||
| Changing cell references | Excel Discussion (Misc queries) | |||
| Changing Cell Fill Colour | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
| Changing number in same cell | Excel Worksheet Functions | |||
Threaded Mode
