Check Box

[Troll Farmer]

Good Afternoon,

Need some help in the enclosed, it's a performance evaluation.if it can be created in a check box with automated calculation.

Please advise if it can be perfected in some other formats with calculation

 

[PCosta87]

Hi,

Welcome to the forum

Please refer to the attached sample...
You should probably avoid using check boxes for this one as it would allow you to select more than one column in each of the 20 rows... option buttons are better in my opinion.

I didn't understand the last part, though: Figure Showing with "Out of Calculation like "88 out of 100". Could you explain it better?

Hope this helps

 

[NARAYANK991]

Hi ,

A formula such as :

=SUM(E24:J24) & " out of " & J24 * COUNTA($B$3:$D$22) * 0.1

will display the text string : 88 out of 100.

In cell E26 , use the formula :

=SUM(E24:J24)/100

to display the percentage as 88.00% , once the cell has been formatted as Percentage.

Narayan

 

[bosco_yip]

Another option,

to use Custom cell format, and change 1 to tick like a Checkbox.

1] Select E3:J20 >> Format Cells >> Number tab >> Custom, in the type box enter: [=1]ü;

and >> Font tab, choose "Wingdings" >> OK

2] All the original content/formula without change

Regards

 

[Troll Farmer]

Thank You all for your help i have run the formula's but it seems some error, i have attached sheet, errors highlighted in Yellow

 

[PCosta87]

Hi,

You should probably use group boxes as they will ensure that all option buttons inside can't be used simultaneously...

Attached!

 

[Troll Farmer]

Appreciate your prompt reply...but the figures in Grand total changes whenever i tick other boxes....grand total is like marks...60 out of 100 but the figure 100 changes as the value in J34 changes

 

[PCosta87]

Hi,

I'm not sure I follow, but if "out of ..." is to be always "out of 100" then simply type in 100 instead of calculating it based on J34.

See attached.

 

[Troll Farmer]

Thank so much...Actually kind of i am on a beginners level in excel...don't know so much about the formulas...anyways it's perfect and excellent.

Have a nice evening you all

 

[PCosta87]

You are welcome