Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm not sure how to word this.. but here goes.
I have an old spreadsheet with a client's price list. The client faxed their new price list to me which should be the old price +15%. In our spreadsheet, I'm checking their calculations by using a formula to add 15% to the old price. Once I check the list they sent and let them know which are incorrect, I need the cell contents to be the result of the formula and not the formula itself. For example, cell A1's value is $111.85. Cell B1's value is =A1+ (A1*15%). Cell B1 displays $128.63. I check it against the client's fax and the numbers match. Now I need the value of cell C1 to be $128.63 - no formula, just the formula's results. How can I acheive this without manually typing the value? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying the Hyperlink function result without copying the actual formula | Excel Worksheet Functions | |||
Switching Between Showing Formula Or Actual Result In A Cell ? | New Users to Excel | |||
Changing the Contents of a Cell | Excel Discussion (Misc queries) | |||
return a cell contents as the result of usiing "small" | Excel Worksheet Functions | |||
Display actual contents of cell | Excel Discussion (Misc queries) |