Percentage function

[Guest]

Hi all,
New boy having fun on Excel here - it's driving me nuts!! :wink:
Trying to find a function to work out percentages but without luck so far - I have a sum at the bottom of a column of numbers (currency format) & in the cell under that I want to have it calculate 5% of that figure. I'm sure it's got to be real simple?
Thanks for your help, Tony

 

[NateO]

Try this in the cell:

+a30*.05

where a30 is your cell with the sum.

Cheers, Nate

 

[Guest]

Nate,
Thanks so much, thats done it!! Finally I can go to bed with a clear head
Cheers, Tony