Hi everybody
how can I calculate percentages on amounts I have in my .xls file?
And how can I create a formula to do so?
I explain better by showing my workbook here:
the 2° column are figures on which I want to calculate percentages, while in the 3° are figures of percentages I have now calculated and added MANUALLY
In this case it's 0,05% on 110.000, 0,05% on 74.000 and so on...


Thanks for all the help
Fabio

I am not sure what 0.05 on 110000 and 0.05 on 74000 mean? How are you arriving at these?

It's 0,05% on those two figures and in 3° column are the results

If I divide the figures by 5000 I get the results.

e.g.

=A2/5000

or multiply by 0.0002

e,g

=A2*0.0002