Question description:
This user has given permission to use the problem statement for this
blog.
I want to use a check box so if it is checked in the link cell is gives me a weight in kg - the formula for the weight is age +4 x 2 and the age is in another cell which I want to like into the formula.
Solved by X. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
02/05/2018 - 05:07
Hi
Excelchat Expert
02/05/2018 - 05:07
Welcome to Got it Pro
User
02/05/2018 - 05:08
hi
Excelchat Expert
02/05/2018 - 05:08
Please tell me more about your requirement
User
02/05/2018 - 05:08
I want to use a check box so if it is checked it gives me a weight in the link cell - the formula for the weight is age +4 x 2 and the age is in another cell which I want to like into the formula.
Excelchat Expert
02/05/2018 - 05:10
I think you will need a developer tab in excel
Excelchat Expert
02/05/2018 - 05:12
Do yet have that?
Excelchat Expert
02/05/2018 - 05:12
you*
Excelchat Expert
02/05/2018 - 05:14
Are you there?
Excelchat Expert
02/05/2018 - 05:14
Please tell
Excelchat Expert
02/05/2018 - 05:18
This is how you apply the checkbox
[Uploaded an Excel file]
Excelchat Expert
02/05/2018 - 05:18
This link will help you if you need any help
Excelchat Expert
02/05/2018 - 05:18
https://www.extendoffice.com/documents/excel/2689-excel-link-checkbox-to-multiple-cells.html
Excelchat Expert
02/05/2018 - 05:19
Since you are not here so giving you a link for reference
Excelchat Expert
02/05/2018 - 05:19
Hope this helps
Excelchat Expert
02/05/2018 - 05:19
Have a great day
Excelchat Expert
02/05/2018 - 05:19
:)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.