Prev: Paste Value Error
Next: Calculate How the Number of Specific word.
From: donnah1234 on 4 Apr 2010 20:47
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

From: Paul on 4 Apr 2010 20:59

If Total Sales are in A1, use:

=A1*0.961

or

=A1-(A1*0.039)




d
o
n
n
a
h
1
2
3
4
;
6
9
0
1
4
7

W
r
o
t
e
:


>
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


--
Paul

- Paul
------------------------------------------------------------------------
Paul's Profile: 1697
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=192880

http://www.thecodecage.com/forumz

From: Russell Dawson on 4 Apr 2010 21:23
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
>
From: "David Biddulph" groups [at] on 5 Apr 2010 05:33
=A1*(1-3.9%)
--
David Biddulph


"donnah1234" <donnah1234(a)discussions.microsoft.com> wrote in message
news:568F0E01-2AF6-4416-8AC5-E59D798CC033(a)microsoft.com...
> 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
>

 | 
Pages: 1
Prev: Paste Value Error
Next: Calculate How the Number of Specific word.