Script for calculating percentages

[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

 

[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