I have a very large spreadsheet of figures that I'd like to add a 9% markup
to. To calculate the 9% we divide the value by .91. How do I apply this
formula to every selected value in the sheet without having to manually
calculate each value???
I have a very large spreadsheet of figures that I'd like to add a 9% markup
to. To calculate the 9% we divide the value by .91. How do I apply this
formula to every selected value in the sheet without having to manually
calculate each value???
Put 9% in an empty cell
select that cell
edit|copy
select your cells to fix
edit|paste special|check multiply.
Clean up that cell with 9%.
VikiFynn wrote:
>
> I have a very large spreadsheet of figures that I'd like to add a 9% markup
> to. To calculate the 9% we divide the value by .91. How do I apply this
> formula to every selected value in the sheet without having to manually
> calculate each value???
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks