View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Justina Justina is offline
external usenet poster
 
Posts: 17
Default formula in Excel 2000 to work %'s

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