If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
Is there a way to take the results of a formula and simply paste the result as a numeric value in a new spreadsheet? I have pricing that is the result of a formula, but need to start a new spreadsheet with new pricing that is calculated from the previous pricing. HELP! Thanks... -- puppypants ------------------------------------------------------------------------ puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654 View this thread: http://www.excelforum.com/showthread...hreadid=499894 |
#2
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
One way:
Edit/Paste Special, select the Values radio button. In article , puppypants wrote: Is there a way to take the results of a formula and simply paste the result as a numeric value in a new spreadsheet? I have pricing that is the result of a formula, but need to start a new spreadsheet with new pricing that is calculated from the previous pricing. HELP! |
#3
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
Try this: Select the source cells EditCopy Select the destination cell EditPaste Special Check: Values Click the [OK] button Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499894 |
#4
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
Thanks - that was the help I needed. Once again, you fine folks here saved the day for me! -- puppypants ------------------------------------------------------------------------ puppypants's Profile: http://www.excelforum.com/member.php...o&userid=28654 View this thread: http://www.excelforum.com/showthread...hreadid=499894 |
#5
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
paste special "values" work fine as a manual solution but how can I assign an
instantaneous cell value as part of as formula? "Ron Coderre" wrote: Try this: Select the source cells EditCopy Select the destination cell EditPaste Special Check: Values Click the [OK] button Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499894 |
#6
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
Do you mean that when you enter the formula it will become static?
Not possible, you can trick some formulas by using iteration like in this example http://www.mcgimpsey.com/excel/timestamp.html look at the "using circular reference" part, otherwise you would need code -- Regards, Peo Sjoblom "bk" wrote in message ... paste special "values" work fine as a manual solution but how can I assign an instantaneous cell value as part of as formula? "Ron Coderre" wrote: Try this: Select the source cells EditCopy Select the destination cell EditPaste Special Check: Values Click the [OK] button Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499894 |
#7
|
|||
|
|||
Results of a Formula As a Value in New Spreadsheet
i haven't explained myself clearly. i want to interrogate a cell whose
values are constantly being updated and store that instantaneous value as a constant elsewhere. an analogy might be storing lap times in addition to total time. "Peo Sjoblom" wrote: Do you mean that when you enter the formula it will become static? Not possible, you can trick some formulas by using iteration like in this example http://www.mcgimpsey.com/excel/timestamp.html look at the "using circular reference" part, otherwise you would need code -- Regards, Peo Sjoblom "bk" wrote in message ... paste special "values" work fine as a manual solution but how can I assign an instantaneous cell value as part of as formula? "Ron Coderre" wrote: Try this: Select the source cells EditCopy Select the destination cell EditPaste Special Check: Values Click the [OK] button Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=499894 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Match then lookup | Tenacity | Worksheet Functions | 10 | December 3rd, 2005 05:30 AM |
abdualmohsn | almedrahe abdualmohsn ahmad | General Discussion | 1 | November 19th, 2005 06:32 PM |
Array formula returning wrong results | TUNGANA KURMA RAJU | General Discussion | 1 | November 19th, 2005 10:29 AM |
Same formula returns different results | Vasant Nanavati | Worksheet Functions | 0 | June 3rd, 2004 07:17 PM |
Simple Excel Formula - Incorrect Results | Rick | Worksheet Functions | 2 | December 12th, 2003 08:51 AM |