Script for calculating percentages


A

adachan3505

Hey all,

I need a script that will do some calculations for me...

For eg:

I've got cells B5 to H5 with the total being in I5

my calculations would be =B5/$I$5*100 for B5 and so on..and I've go
nearly 5000 rows with similar calculations. Is there a script that can
use this calculations and run once???Please help...thanks heaps
 
Ad

Advertisements

N

Niek Otten

If I understand you correctly, you should use

=B5/I5*100

So, without the dollar signs.
You can copy thus formula down and the row numbers will adjust automatically

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


| Hey all,
|
| I need a script that will do some calculations for me...
|
| For eg:
|
| I've got cells B5 to H5 with the total being in I5
|
| my calculations would be =B5/$I$5*100 for B5 and so on..and I've go
| nearly 5000 rows with similar calculations. Is there a script that can
| use this calculations and run once???Please help...thanks heaps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top