ExcelBanter - HOW TO ADD 7% TO LIST OF PRICES

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - HOW TO ADD 7% TO LIST OF PRICES (https://www.excelbanter.com/new-users-excel/177162-how-add-7%25-list-prices.html)

SHIGGA

HOW TO ADD 7% TO LIST OF PRICES

I AM TRYING TO FIND OUT HOW TO ADD 7% TO A LIST OF PRICES, IS THERE AN EASY
FORMULA?

Gord Dibben

HOW TO ADD 7% TO LIST OF PRICES

Place 1.07 in an unused cell.

Copy that then select the range to change.

EditPaste SpecialMultiplyOKEsc.

Delete the 1.07

Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 10:32:03 -0800, SHIGGA
wrote:

I AM TRYING TO FIND OUT HOW TO ADD 7% TO A LIST OF PRICES, IS THERE AN EASY
FORMULA?

All times are GMT +1. The time now is 02:20 AM.