percentage in excel
hi i'm new to excel.
i need to know have to do a formula for percentage. example: total sales £22.50 i need to subtract 3.9% from total sales any help would be great |
percentage in excel
Hi there,
Welcome to Excel. I'll take you through this step by step so you understand fully. We will use three cells to complete your calculation. In A1 in put 22.50. In B1 input 3.9. In C1 this is the formula which will give you the total sales figure less 3.9%. =A1-(A1*B1%) It should be pretty self explanatory, but if not please ask again. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "donnah1234" wrote: hi i'm new to excel. i need to know have to do a formula for percentage. example: total sales £22.50 i need to subtract 3.9% from total sales any help would be great |
percentage in excel
=A1*(1-3.9%)
-- David Biddulph "donnah1234" wrote in message ... hi i'm new to excel. i need to know have to do a formula for percentage. example: total sales £22.50 i need to subtract 3.9% from total sales any help would be great |
All times are GMT +1. The time now is 10:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com