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

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

=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