ExcelBanter - Help Needed in Macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Help Needed in Macro (https://www.excelbanter.com/excel-programming/409589-help-needed-macro.html)

Help Needed in Macro

Hi , can please anybody help me with the macro. I explained every
thing in an excel sheet which you can see in the link below. As I
thought its better to put my question on a sheet to explain clearly.

http://www.savefile.com/files/1511153

Help Needed in Macro

K,

Have a look here
http://www.savefile.com/files/1511437

Mike

"K" wrote:

Hi , can please anybody help me with the macro. I explained every
thing in an excel sheet which you can see in the link below. As I
thought its better to put my question on a sheet to explain clearly.

http://www.savefile.com/files/1511153

Help Needed in Macro

On 18 Apr, 12:49, Mike H wrote:
K,

Have a look herehttp://www.savefile.com/files/1511437

Mike

"K" wrote:
Hi , can please anybody help me with the macro. *I explained every
thing in an excel sheet which you can see in the link below. As I
thought its better to put my question on a sheet to explain clearly.

http://www.savefile.com/files/1511153- Hide quoted text -

- Show quoted text -

Just a small question that if i have percentages in decimals like for
example
A_Percents(1) = 7.69
A_Percents(2) = 8.59
A_Percents(3) = 10
A_Percents(4) = 8
A_Percents(5) = 9.44
A_Percents(6) = 6
A_Percents(7) = 7.15
A_Percents(8) = 20.02
A_Percents(9) = 3.33
A_Percents(10) = 5.58
A_Percents(11) = 10.23
A_Percents(12) = 3.97
and when these percentages get multiplied by the amount we say like
2170 then obvesly i'll get result in decimals. Is there way that we
can round figures just doing some change in code "Sheets(2).Cells(k,
5).Value = (A_Percents(J) / 100) *
Sheets(1).Cells(i, 5).Value" in macro so i can get figures
rounded to near 10 or 100. Please do reply