View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default How do I increase a $ by a % to a current amount in a cell?

Say the $ amount are in a given column, say column G. In an unused cell enter:

1.3

copy this cell and:

Edit Paste Special Multiply onto the cells in column G
--
Gary''s Student - gsnu200777


"~D.." wrote:

We resell equipment with a 30% upcharge for profit. How can I increase all $
amounts to include the upcharge without manually re-entering the amount?

I am relatively new at this. Thanks!