G Guest Oct 22, 2004 #1 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?
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 Oct 22, 2004 #2 Hi - enter 0.95 in an empty cell - copy this cell - select your range of cells - goto 'Edit - Paste Special' and chose 'Divide'
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 Oct 24, 2004 #3 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
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
