Excel increasing price by 5%

C

cyndirecinos

I know how to do individually (={current price)/.95), but is their a way to
do for a group of cells? some way I could just add the /.95?
 
F

Frank Kabel

Hi
- enter 0.95 in an empty cell
- copy this cell
- select your range of cells
- goto 'Edit - Paste Special' and chose 'Divide'
 
M

Mike A

A better formula is CurrentPrice * 1.05.

Dividing by .95 gives incorrect results. This is the number that
CurrentPrice is 95% of, not the number that is 5% more than CurrentPrice:

500/.95 = 526.32 (wrong result)
500*1.05 = 525 (right result)



Mike Argy
Custom Office solutions and
Windows/UNIX applications
 
Top