Calculations based on checkbox selection

[chinaboy]

Hi guys, I am not sure how to make this work. I would like to have about 20 rows of data. I am trying to make it that when the user selects a checkbox it will populate the increase in Column E. For each row I will have a 10 checkboxes. Only one checkbox can be selected per row. When one is selected, the others should be unchecked.

In Column D will have the salary for each person........Col. E will have the increase amount.......each check box will represent a percentage.

For example....1st checkbox = 2% .....2nd checkbox = 4%.......etc.

So if user select checkbox 1, then it should multiply salary by 2% and place the result in Column E.......If select checkbox 2 then it should multiply salary by 4% and place the reslut in column E.

Can someone please help me with the best way to go about this. Or point me to a working example.

Thanks

 

[bertie]

Here are a couple of functions for you to check in the Excel Help file:

CEILING - this rounds up to the nearest multiple of e.g. 24
FLOOR - this rounds down to the nearest multiple of e.g. 24

There is another function which claims to do this automatically. It is not available by default. In the link below scroll down to MROUND. NB I have never used this before.

http://www.ozgrid.com/Excel/excel-rounding.htm

Sorry to have to do things this way but you appear to have moved things around from my version

Bertie

 

[chinaboy]

Thanks for the information. I will give it a try.