E
enufsaid878
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?
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?