TECHNOLOGY FOR TEACHERS AND STUDENTS. **AND those in the corporate world**. I've used this tool when creating standardized notes for my phone agents. If they check the box, it adds it to the note they'll then copy in paste into our system! Thanks for the tip!
The formula =IF(G2=FALSE, "Delinquent", "Done") can be rewritten as: =IF(G2,"Done","Delinquent") Notes: 1) No need for the actual comparison, as the cell used (G2) already contains a boolean expression (a boolean constant). 2) It's not necessary to put a space after a comma when passing arguments to a function in a formula. That being said, I would find it a useful feature sometimes - e.g. to use it for some more striking separation when dealing with particularly long and/or complex formulas. *Any whitespace in formulas does get saved exactly as entered but is completely ignored during parsing.*
I'm finding your tutorials so helpful I feel I have learned so much. I have been following your tutorials for about a month and I feel I have learned so much thank you so much. Can you teach to do invoices in Excel.
Thanks for your kind comments. I will add Excel Invoices to my list of tutorials to make. It may take a while to get to it, as I already have several videos in the "pipeline." Thanks for watching.
I’m very happy to follow along whenever I see practical file link in your videos. Thank you very much. I can’t to earn my first salary I will be supporting this channel every 3 months
In Google Sheets, you can use conditional formatting directly on the cells that contain the check boxes, you also don't need to have a hidden column for true/false because the checkbox automatically equals true if it's checked.
Well done, first I didn't manage executing the function IF, because in my case that is distinguished with ";" not with ",". Thank you very much for granting this information !!!
Hello! A good tip, you can just press in the cell twice where you drag and then the Excel will fill until the last filled line of your spreadsheet. If there's no line filled, it won't do anything Thanks for the tutorial!
Thank you for the checkbox video. My next search is how to use those check boxes to capture and calculate a total value. For example, column E has 10 rows of check boxes. When you check a box, that gives you one point. I then need to get a total of how many points were in that column. For example, 3 checked boxes equals 3 points in another cell. Now let's take that a step further. Column F has another 10 rows of check boxes. However, each of those points are worth 2 points. So now I need to calculate and show the total points in another cell. For example, 3 checked boxes displays 6 points in another cell.
Hi thanks for the tutorial videos so amazing and great. Hope you will notice me and I just want to ask if I want to delete the check box what I'm gonna do hope you will answer me thanks in advance..
Thanks for your lecture. I'm facing a problem with using the filter along with using checkboxes, means I don't want my checkbox to reflected on hidden by filter, could you help please? Thanks
Thanks for your a wonderful video, i have question, what if need to make that theckbok to reflects on multiple row by 1 or zero, means if i check the whole row or column is 1 if not then 0. I would like to know from you. Thx a lot
Hello, if I have a checklist all set up that are linked to a filter. Is there a way to make a collapsible checklist under each to sub divide my main checklist items? I know I can group and collapse rows, but they don't link to the master row I would like them to follow. Any help would be greatly appreciated!! Thank you!
Badr gaming not with the simple, form controls checkboxes. The checkbox has to be linked with a cell in your workbook, so that Excel formulae can work with the data. Once you’ve given the data a “home” in a linked cell in your spreadsheet, you can then use it in any formula you want. For data in cells which you don’t want the spreadsheet user to see, you have a couple of options: you can hide the column or row with those cells, like in the tutorial, or you can put the linked cell in a separate worksheet (tab) and then hide that worksheet.
No, the checkbox is empty or ticked - binary choice. If you wanted say [X] -v- [ ] you can use simple dead text, but the sheet drives from the true false statement in the driving case or a non-linked manual tick in the update case.
Also, it is easier to read and maintain sheets if the logic also flows to either adjacent cells (hidden or not) or for European writing languages from left to right... ... otherwise, it is amazingly easy to get in a mess, very fast.
You didn’t need to write “IF(G2=false,…”. Instead you could have written “IF(G2,…”, because G2 already contains the result of the test (“true” or “false”).
Sir which version of excel are you using? I am asking because I don't have the developer option due to which I am not able to practice it. Would you please mention the version. Thanks
The author did mention, developer button doesn't come in default,open your costumize ribbon and check the developer box to make it appear on you screen。
Shaer Sajeeb If you want to use a form control to run a task I think you’d need to record a macro to add one to the value in the cell, then insert a button instead of a checkbox and assign that macro to it.
duplicating fields (like true=done, false=delinquent) and also repeating data for example you have "Customer service" or "Management" words like 100 times in your sheet, bad anomalies :/ I know these are just examples for excel and not database programming, but at least here is my comment to note this its not good way to do it, better make a spearate sheet/table for the departments index them (e.g 1=management ,2=sales ,3=assistants etc) then dont store text informations like "customer service"
TECHNOLOGY FOR TEACHERS AND STUDENTS. **AND those in the corporate world**. I've used this tool when creating standardized notes for my phone agents. If they check the box, it adds it to the note they'll then copy in paste into our system! Thanks for the tip!
The formula
=IF(G2=FALSE, "Delinquent", "Done")
can be rewritten as:
=IF(G2,"Done","Delinquent")
Notes:
1) No need for the actual comparison, as the cell used (G2) already contains a boolean expression (a boolean constant).
2) It's not necessary to put a space after a comma when passing arguments to a function in a formula. That being said, I would find it a useful feature sometimes - e.g. to use it for some more striking separation when dealing with particularly long and/or complex formulas. *Any whitespace in formulas does get saved exactly as entered but is completely ignored during parsing.*
or it can be also written as
=IF(NOT(G2), "Delinquent", "Done")
I'm finding your tutorials so helpful I feel I have learned so much. I have been following your tutorials for about a month and I feel I have learned so much thank you so much. Can you teach to do invoices in Excel.
Thanks for your kind comments. I will add Excel Invoices to my list of tutorials to make. It may take a while to get to it, as I already have several videos in the "pipeline." Thanks for watching.
I love this tutorial, I have learned a lot. I really appreciate and will definitely support you.
I’m extremely grateful for your instruction. Thanking you once again Sir
You make learning interesting
I’m very happy to follow along whenever I see practical file link in your videos. Thank you very much. I can’t to earn my first salary I will be supporting this channel every 3 months
You are the best Excel teacher on UA-cam that I have come across. Thankyou - going to put on some Dep Mode on whilst I continue practising !
In Google Sheets, you can use conditional formatting directly on the cells that contain the check boxes, you also don't need to have a hidden column for true/false because the checkbox automatically equals true if it's checked.
Well done, first I didn't manage executing the function IF, because in my case that is distinguished with ";" not with ",". Thank you very much for granting this information !!!
Hello!
A good tip, you can just press in the cell twice where you drag and then the Excel will fill until the last filled line of your spreadsheet. If there's no line filled, it won't do anything
Thanks for the tutorial!
Thank you for the checkbox video. My next search is how to use those check boxes to capture and calculate a total value. For example, column E has 10 rows of check boxes. When you check a box, that gives you one point. I then need to get a total of how many points were in that column. For example, 3 checked boxes equals 3 points in another cell. Now let's take that a step further. Column F has another 10 rows of check boxes. However, each of those points are worth 2 points. So now I need to calculate and show the total points in another cell. For example, 3 checked boxes displays 6 points in another cell.
EXCELLENT, VERY EDUCATIVE. SIR ONE MORE REQUEST. KINDLY PROVIDE LINK TO DOWNLOAD PRACTICE FILES.
You are so good thank you for making it easy🙏🏽🙏🏽🙏🏽🙏🏽
Thank you, very informative.
Wonderful video
Thanks for this tutorial. I will like to prevent my colleague from unchecking my box, how can i protect it?
Thank you !!
big help....... thank you.......
Hi thanks for the tutorial videos so amazing and great. Hope you will notice me and I just want to ask if I want to delete the check box what I'm gonna do hope you will answer me thanks in advance..
Is their a way to change the visual of the box and the tick?
The default looks dull.
How can I turn the cell with the check mark a color based on being checked or unchecked?
Do these check boxes and functions work on a shared workbook?
Thanks for your lecture.
I'm facing a problem with using the filter along with using checkboxes, means I don't want my checkbox to reflected on hidden by filter, could you help please?
Thanks
Thank you!
Thanks for your a wonderful video, i have question, what if need to make that theckbok to reflects on multiple row by 1 or zero, means if i check the whole row or column is 1 if not then 0.
I would like to know from you.
Thx a lot
Can you tell what theme does your Excel have in your toolbar and ribbon? I couldn't find this kind of minimalistic theme in my Excel 2019.
Hello Sir, How can you relate two check boxes together, means if one is checked, the other is automatically unchecked. Thank you.
Hello, if I have a checklist all set up that are linked to a filter. Is there a way to make a collapsible checklist under each to sub divide my main checklist items? I know I can group and collapse rows, but they don't link to the master row I would like them to follow. Any help would be greatly appreciated!! Thank you!
Gracias :)
Can I use conditional formatting with check box, example: if check box is checked then fill with red???
Badr gaming not with the simple, form controls checkboxes. The checkbox has to be linked with a cell in your workbook, so that Excel formulae can work with the data. Once you’ve given the data a “home” in a linked cell in your spreadsheet, you can then use it in any formula you want. For data in cells which you don’t want the spreadsheet user to see, you have a couple of options: you can hide the column or row with those cells, like in the tutorial, or you can put the linked cell in a separate worksheet (tab) and then hide that worksheet.
How to mass delete the tick boxes?
Is it possible to create an automation where the check boxes gets automatic"check" if done, and "x" if not? Referencing to another column?
No, the checkbox is empty or ticked - binary choice. If you wanted say [X] -v- [ ] you can use simple dead text, but the sheet drives from the true false statement in the driving case or a non-linked manual tick in the update case.
Also, it is easier to read and maintain sheets if the logic also flows to either adjacent cells (hidden or not) or for European writing languages from left to right... ... otherwise, it is amazingly easy to get in a mess, very fast.
If I use 'wrap text' in the D6 the checkboxes don't move with the rows. How do I fix that?
Hold shift when you drop the checkbox onto its designated cell. This will keep it locked to the cell you assign it to.
It is nice ..
I cannot edit check box message by right click
You didn’t need to write “IF(G2=false,…”. Instead you could have written “IF(G2,…”, because G2 already contains the result of the test (“true” or “false”).
Stéphane English good to know thanks
good
Sir which version of excel are you using? I am asking because I don't have the developer option due to which I am not able to practice it. Would you please mention the version. Thanks
File, Options, Customize Ribbon, Right hand side.
2016
@@nheriecardona8301 I have 2016 but don't have the option "developer"
The author did mention, developer button doesn't come in default,open your costumize ribbon and check the developer box to make it appear on you screen。
@@nheriecardona8301 thanks Ma'm
I want checkbox with automatic adding number.
Shaer Sajeeb If you want to use a form control to run a task I think you’d need to record a macro to add one to the value in the cell, then insert a button instead of a checkbox and assign that macro to it.
duplicating fields (like true=done, false=delinquent) and also repeating data for example you have "Customer service" or "Management" words like 100 times in your sheet, bad anomalies :/ I know these are just examples for excel and not database programming, but at least here is my comment to note this
its not good way to do it, better make a spearate sheet/table for the departments index them (e.g 1=management ,2=sales ,3=assistants etc) then dont store text informations like "customer service"
And remember boys and girls. Update your driver safety training otherwise you're a delinquent xD I'm pretty sure this file would be a HR violation
@Doctor Deceit "I'm pretty sure this file would be a HR violation" - HR violations are permitted. Syntax violations, on the other hand... ;-P