1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Check Box

Discussion in 'Ask an Excel Question' started by Troll Farmer, Mar 20, 2017.

  1. Troll Farmer

    Troll Farmer New Member

    Messages:
    4
    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

    Attached Files:

  2. PCosta87

    PCosta87 Well-Known Member

    Messages:
    709
    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

    Attached Files:

    Thomas Kuriakose likes this.
  3. NARAYANK991

    NARAYANK991 Excel Ninja

    Messages:
    14,325
    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
    Thomas Kuriakose likes this.
  4. bosco_yip

    bosco_yip Well-Known Member

    Messages:
    877
    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

    Attached Files:

    Thomas Kuriakose and PCosta87 like this.
  5. Troll Farmer

    Troll Farmer New Member

    Messages:
    4
    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

    Attached Files:

  6. PCosta87

    PCosta87 Well-Known Member

    Messages:
    709
    Hi,

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

    Attached!

    Attached Files:

    Thomas Kuriakose likes this.
  7. Troll Farmer

    Troll Farmer New Member

    Messages:
    4
    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

    Attached Files:

  8. PCosta87

    PCosta87 Well-Known Member

    Messages:
    709
    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.

    Attached Files:

    Thomas Kuriakose likes this.
  9. Troll Farmer

    Troll Farmer New Member

    Messages:
    4
    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
  10. PCosta87

    PCosta87 Well-Known Member

    Messages:
    709
    You are welcome :)

Share This Page