ExcelBanter - Minusing 17.5% off a column of figures

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Minusing 17.5% off a column of figures (https://www.excelbanter.com/excel-worksheet-functions/190811-minusing-17-5%25-off-column-figures.html)

Sue

Minusing 17.5% off a column of figures

I have a column of total cost but I would like to have a new column
calculating that total cost minus 17.5%, Please can someone help me in easy
terms on how to do this.

Thankyou very very much x

Stefi

Minusing 17.5% off a column of figures

It's really easy: if your column of total cost is G then enter =G2*0,825 in
the new column and fill it down as necessary!

Regards,
Stefi

€žSue€ ezt Ã*rta:

I have a column of total cost but I would like to have a new column
calculating that total cost minus 17.5%, Please can someone help me in easy
terms on how to do this.

Thankyou very very much x

Mike H

Minusing 17.5% off a column of figures

Maybe

=A1-(A1*17.5%)

Drag down

Mike

"Sue" wrote:

I have a column of total cost but I would like to have a new column
calculating that total cost minus 17.5%, Please can someone help me in easy
terms on how to do this.

Thankyou very very much x

All times are GMT +1. The time now is 02:58 PM.