If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|