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...?????