LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Holding the result of a formula constant or frozen

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a way to make a result from an IF or SUM a constant? [email protected] Excel Discussion (Misc queries) 1 April 8th 08 03:04 PM
Set a constant from a formula in VBA Ed Excel Discussion (Misc queries) 1 December 1st 06 01:31 AM
holding the result constant [email protected] Excel Worksheet Functions 1 July 14th 06 11:46 PM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM
Subtracting a Countif result from a constant Bernie Deitrick Excel Worksheet Functions 4 September 6th 05 10:07 PM


All times are GMT +1. The time now is 11:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"