Hello all. First off I want to thank the forum--for almost a year now this has been a place I've found a ton of help as a new user. I appreciate all of the work that goes into helping anyone and everyone (beginner, advanced and otherwise).
Question
I've included an example. my spreadsheet is a gpa calculator. In one section there are two course groupings listed (only ONE is to be included in the gpa calculation).
When the user selects a checkbox (group 1 or group 2), I would like the opposing course group to be cleared (just the "letter grade attained" column) of any value and disabled (so the user can't put a value into the opposing course group).
I feel like this could be done with something simple like
IF checkbox is true then value is 0 and locked is true
else if locked = false
If anyone has any input it would be greatly appreciated...
IF you decide to help and can try to explain to me (briefly of course) how and why it doesn't work my way and needs to be another way that would be amazing...
Thank you in advance, sorry for the novel.
-Eric (a student willing to learn)
*Note - checkbox (not sure whether it should be an activeX Control form) would be right beside the titles "Group 1" and "group 2".
In a perfect world -Removing the course group that is disabled from the GPA calculation isn't neccessary but it would be ideal...
<table border="0" cellpadding="0" cellspacing="0" width="525"><colgroup><col style="mso-width-source:userset;mso-width-alt:2986;width:63pt" width="84"> <col style="mso-width-source:userset;mso-width-alt:10126;width:214pt" width="285"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:2816;width:59pt" width="79"> </colgroup><tbody><tr style="height:52.8pt" height="70"> <td style="height:52.8pt;width:63pt" height="70" width="84">
</td> <td style="width:214pt" width="285">
</td> <td style="width:58pt" width="77">Hours/week</td> <td class="xl66" style="width:59pt" width="79">Letter Grade attained in course</td> </tr> <tr style="height:13.2pt" height="18"> <td colspan="2" class="xl71" style="height:13.2pt" height="18">Level 5 - Add'l Req: Take 1 of the following Groups:
</td> <td class="xl68">
</td> <td class="xl70">
</td> </tr> <tr style="height:13.2pt" height="18"> <td class="xl65" style="height:13.2pt" height="18">Group 1</td> <td>
</td> <td class="xl68">
</td> <td class="xl70">
</td> </tr> <tr style="height:13.2pt" height="18"> <td style="height:13.2pt" height="18">xx</td> <td>xx</td> <td class="xl68">3</td> <td class="xl67">d</td> </tr> <tr style="height:13.2pt" height="18"> <td style="height:13.2pt" height="18">xx</td> <td>xx</td> <td class="xl68">3</td> <td class="xl67" style="border-top:none">d</td> </tr> <tr style="mso-height-source:userset;height:26.4pt" height="35"> <td colspan="2" class="xl72" style="height:26.4pt" height="35">OR</td> <td class="xl68">
</td> <td class="xl69">Level GPA</td> </tr> <tr style="height:13.2pt" height="18"> <td class="xl65" style="height:13.2pt" height="18">Group 2</td> <td>
</td> <td class="xl68">
</td> <td class="xl70">
</td> </tr> <tr style="height:13.2pt" height="18"> <td style="height:13.2pt" height="18">xx</td> <td>xx</td> <td class="xl68">6</td> <td class="xl67">d</td> </tr> </tbody></table>
Question
I've included an example. my spreadsheet is a gpa calculator. In one section there are two course groupings listed (only ONE is to be included in the gpa calculation).
When the user selects a checkbox (group 1 or group 2), I would like the opposing course group to be cleared (just the "letter grade attained" column) of any value and disabled (so the user can't put a value into the opposing course group).
I feel like this could be done with something simple like
IF checkbox is true then value is 0 and locked is true
else if locked = false
If anyone has any input it would be greatly appreciated...
IF you decide to help and can try to explain to me (briefly of course) how and why it doesn't work my way and needs to be another way that would be amazing...
Thank you in advance, sorry for the novel.
-Eric (a student willing to learn)
*Note - checkbox (not sure whether it should be an activeX Control form) would be right beside the titles "Group 1" and "group 2".
In a perfect world -Removing the course group that is disabled from the GPA calculation isn't neccessary but it would be ideal...
<table border="0" cellpadding="0" cellspacing="0" width="525"><colgroup><col style="mso-width-source:userset;mso-width-alt:2986;width:63pt" width="84"> <col style="mso-width-source:userset;mso-width-alt:10126;width:214pt" width="285"> <col style="mso-width-source:userset;mso-width-alt:2730;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:2816;width:59pt" width="79"> </colgroup><tbody><tr style="height:52.8pt" height="70"> <td style="height:52.8pt;width:63pt" height="70" width="84">
</td> <td style="width:214pt" width="285">
</td> <td style="width:58pt" width="77">Hours/week</td> <td class="xl66" style="width:59pt" width="79">Letter Grade attained in course</td> </tr> <tr style="height:13.2pt" height="18"> <td colspan="2" class="xl71" style="height:13.2pt" height="18">Level 5 - Add'l Req: Take 1 of the following Groups:
</td> <td class="xl68">
</td> <td class="xl70">
</td> </tr> <tr style="height:13.2pt" height="18"> <td class="xl65" style="height:13.2pt" height="18">Group 1</td> <td>
</td> <td class="xl68">
</td> <td class="xl70">
</td> </tr> <tr style="height:13.2pt" height="18"> <td style="height:13.2pt" height="18">xx</td> <td>xx</td> <td class="xl68">3</td> <td class="xl67">d</td> </tr> <tr style="height:13.2pt" height="18"> <td style="height:13.2pt" height="18">xx</td> <td>xx</td> <td class="xl68">3</td> <td class="xl67" style="border-top:none">d</td> </tr> <tr style="mso-height-source:userset;height:26.4pt" height="35"> <td colspan="2" class="xl72" style="height:26.4pt" height="35">OR</td> <td class="xl68">
</td> <td class="xl69">Level GPA</td> </tr> <tr style="height:13.2pt" height="18"> <td class="xl65" style="height:13.2pt" height="18">Group 2</td> <td>
</td> <td class="xl68">
</td> <td class="xl70">
</td> </tr> <tr style="height:13.2pt" height="18"> <td style="height:13.2pt" height="18">xx</td> <td>xx</td> <td class="xl68">6</td> <td class="xl67">d</td> </tr> </tbody></table>
