View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Excel Formula Error

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