ExcelBanter - function/formula for adding 30%

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - function/formula for adding 30% (https://www.excelbanter.com/excel-programming/347531-re-function-formula-adding-30%25.html)

Gord Dibben

function/formula for adding 30%

Without code or formulas.

Enter 1.3 in a cell.

Copy that cell.

Select old prices cells and Paste SpecialMultiplyOKEsc.

Delete the 1.3 cell.

Gord Dibben Excel MVP

On Tue, 6 Dec 2005 20:07:02 -0800, gusputra1967
wrote:

I have an old price list in excel and want to add 30% to all the old prices,
what formula do I have to use for this?

All times are GMT +1. The time now is 12:11 PM.