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.
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.
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
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!
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 !!!
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.
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!
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 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
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
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.
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。
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”).
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"