How to perform calculation for multiple columns and rounding off using macro

[raja15feb]

Hi,

I trying to develop a macro to calculate the premium of policies. For a single premium i am able to do it but for multiple premiums i don't know how to do it. I have attached the screenshot. In the screenshot there will be four columns (Benefit Premium, Contribution Percentage, Payment frequency and Bill generation frequency). I will explain how it will be calculating. After i click calculate button, Premium to be paid is calculated as follows

Premium to be Paid = (Benefit Premium * Contribution percentage*Payment frequency)/Bill generation frequency

Likewise it have calculate for each row and add all the premium to be paid of each row. Premium to be paid should be displayed upto 4 decimals and then it should be round off to 2 decimals. Please help

[Draconi]

Hi,

Try this code. Attached is a spreadsheet that you can try as well. Let me know how it goes.

**************See next post****************************************************

Draconi

[Draconi]

Hi,

Try this code. Attached is a spreadsheet for you to try as well.

Please Login or Register  to view this content.

Draconi