Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate a part of a worksheet
I have one calculation the creates a random number. I have another
calculation that compares an input number to the random number. The problem is that when the spreadsheet is calculated the random number changes and is therefore always different from the input number. Is there a way to calculate the comparison without calculating the random number? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate a part of a worksheet
Edit Copy the random number Edit Paste Special Values
"History Lover" wrote: I have one calculation the creates a random number. I have another calculation that compares an input number to the random number. The problem is that when the spreadsheet is calculated the random number changes and is therefore always different from the input number. Is there a way to calculate the comparison without calculating the random number? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate a part of a worksheet
You can use Range.Calculate from VBA, or download my RangeCalc addin from
http://www.decisionmodels.com/downloads.htm#RngCalc This adds a button to Excel that calculates the selected range and shows you the time taken. Charles ______________________ Decision Models FastExcel 2.3 now available Name Manager 4.0 now available www.DecisionModels.com "History Lover" <History wrote in message ... I have one calculation the creates a random number. I have another calculation that compares an input number to the random number. The problem is that when the spreadsheet is calculated the random number changes and is therefore always different from the input number. Is there a way to calculate the comparison without calculating the random number? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to remove gridlines from part of a worksheet only | Excel Worksheet Functions | |||
copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
Locking Part of a Worksheet/Tab | Excel Discussion (Misc queries) | |||
how can I insert rows in part of worksheet | Excel Worksheet Functions | |||
How do I add gridlines to a colored part of a worksheet? | Excel Worksheet Functions |