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!
|