Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi there
I have created an excel that calculates a value based on a number of user defined variables. The excel is calulating everything correctly. However, I need the value calculated to remain static since once it has been calculated, a final user input will chnage some of the variables that contributed to the original calculated value. For example, the calculated value is 15% and resides in cell C17. A user can then input a value into cell C18 (that may or may not be equal to 15%) but this value will affect the variables that resulted in the original calculated value in C17. I want the value in C17 to remain constant after it is originally calculated so that the user can compare what has been originally calculated to what they are choosing to enter in C18. Any ideas on how to do this? Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Is there a way to make a result from an IF or SUM a constant? | Excel Discussion (Misc queries) | |||
Set a constant from a formula in VBA | Excel Discussion (Misc queries) | |||
holding the result constant | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Subtracting a Countif result from a constant | Excel Worksheet Functions |