How do i get a percentage figure from a total i give using a formula and what
formula do i use in Excel 2000...I need help i cant figure the quik way to do
this basic math in excel...?????

If you want to know what percentage A1 is of A2, use =A1/A2 and format the
result as percentage.
--
David Biddulph

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a formula and
what
formula do i use in Excel 2000...I need help i cant figure the quik way to
do
this basic math in excel...?????

Thankyou for your reply...If i was trying to work out say 5% of 1 particular
column, what formula and how would i do that? Any help would be great

"David Biddulph" wrote:

If you want to know what percentage A1 is of A2, use =A1/A2 and format the
result as percentage.
--
David Biddulph

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a formula and
what
formula do i use in Excel 2000...I need help i cant figure the quik way to
do
this basic math in excel...?????

To calculate 5% of the sum of the cells in B column, and assuming you have a
heading in cell B1, then:
=Sum(B2:B65536)*.05
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Justina" wrote in message
...
Thankyou for your reply...If i was trying to work out say 5% of 1
particular
column, what formula and how would i do that? Any help would be great

"David Biddulph" wrote:

If you want to know what percentage A1 is of A2, use =A1/A2 and format
the
result as percentage.
--
David Biddulph

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a formula
and
what
formula do i use in Excel 2000...I need help i cant figure the quik way
to
do
this basic math in excel...?????

I still dont understand!!! I am stuck

"Anne Troy" wrote:

To calculate 5% of the sum of the cells in B column, and assuming you have a
heading in cell B1, then:
=Sum(B2:B65536)*.05
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Justina" wrote in message
...
Thankyou for your reply...If i was trying to work out say 5% of 1
particular
column, what formula and how would i do that? Any help would be great

"David Biddulph" wrote:

If you want to know what percentage A1 is of A2, use =A1/A2 and format
the
result as percentage.
--
David Biddulph

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a formula
and
what
formula do i use in Excel 2000...I need help i cant figure the quik way
to
do
this basic math in excel...?????

If you want to calculate 5% of A1, the formula is =A1*5%.
To use Excel, you need to know what you want it to calculate for you.
You're probably going to need to learn some basic mathematics before you use
Excel.
--
David Biddulph

"Justina" wrote in message
...
I still dont understand!!! I am stuck

"Anne Troy" wrote:

To calculate 5% of the sum of the cells in B column, and assuming you
have a
heading in cell B1, then:
=Sum(B2:B65536)*.05

"Justina" wrote in message
...
Thankyou for your reply...If i was trying to work out say 5% of 1
particular
column, what formula and how would i do that? Any help would be great

"David Biddulph" wrote:

If you want to know what percentage A1 is of A2, use =A1/A2 and format
the
result as percentage.

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a formula
and
what
formula do i use in Excel 2000...I need help i cant figure the quik
way
to
do
this basic math in excel...?????

Thanks David for your help. I do have more than enough math skills, i just
wanted to be able to do it all on Excel and didnt understand how to use
formulas at all! I am getting there though...Once again, thankyou for your
help...Its quite easy once someone explains it, Cheers!!!

"David Biddulph" wrote:

If you want to calculate 5% of A1, the formula is =A1*5%.
To use Excel, you need to know what you want it to calculate for you.
You're probably going to need to learn some basic mathematics before you use
Excel.
--
David Biddulph

"Justina" wrote in message
...
I still dont understand!!! I am stuck

"Anne Troy" wrote:

To calculate 5% of the sum of the cells in B column, and assuming you
have a
heading in cell B1, then:
=Sum(B2:B65536)*.05

"Justina" wrote in message
...
Thankyou for your reply...If i was trying to work out say 5% of 1
particular
column, what formula and how would i do that? Any help would be great

"David Biddulph" wrote:

If you want to know what percentage A1 is of A2, use =A1/A2 and format
the
result as percentage.

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a formula
and
what
formula do i use in Excel 2000...I need help i cant figure the quik
way
to
do
this basic math in excel...?????

Okay. I've re-read your original question. I'll try this answer instead:
If you want to find out what 5% of 2000 is in Excel, type this into any
cell:
=2000*5%
and hit enter.
If the answer is not 100, then hit Format--Cells, and make sure NUMBER is
selected in the left-hand side, and the number of decimals you want to
appear is chosen.
****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Justina" wrote in message
...




























Thanks David for your help. I do have more than enough math skills, i just
wanted to be able to do it all on Excel and didnt understand how to use
formulas at all! I am getting there though...Once again, thankyou for your
help...Its quite easy once someone explains it, Cheers!!!

"David Biddulph" wrote:

If you want to calculate 5% of A1, the formula is =A1*5%.
To use Excel, you need to know what you want it to calculate for you.
You're probably going to need to learn some basic mathematics before you
use
Excel.
--
David Biddulph

"Justina" wrote in message
...
I still dont understand!!! I am stuck

"Anne Troy" wrote:

To calculate 5% of the sum of the cells in B column, and assuming you
have a
heading in cell B1, then:
=Sum(B2:B65536)*.05

"Justina" wrote in message
...
Thankyou for your reply...If i was trying to work out say 5% of 1
particular
column, what formula and how would i do that? Any help would be
great

"David Biddulph" wrote:

If you want to know what percentage A1 is of A2, use =A1/A2 and
format
the
result as percentage.

"Justina" wrote in message
...
How do i get a percentage figure from a total i give using a
formula
and
what
formula do i use in Excel 2000...I need help i cant figure the
quik
way
to
do
this basic math in excel...?????