Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
Formula looks like it might be =COUNTIF(C4:G4, TRUE)/COUNTA(C4:G4) so basically divide the number of checked boxes by the number of total boxes to her the percentage
Put formula in comments, it is bit hard to see formula, as it's going fast
it's a simple average?
What the top reply said. Example: Attendance = 3, Works days = 5.(3/5)100 = 60%
=COUNTIF (C4:G4, true)/COUNTA(C4:64). That is😅
thank you !
Do you have an easy way to track sick and vacation leave?
This is a google sheet not excel. In my experience you cannot insert a checkbox in excel this way.
Bro both r same thing, 70-80% features r same only somethings r different.
This work at google sheet . Not excel
Proxy becomes easy😂😂😂
Thanks
How did you do that? You still have to assign each checkbox in each cell.
Formula is what needs explanation yet there's none! I am sweating😅
Please put formula in comments.. It is very small and passing so quickly.
put the formula in comment cannot see it too fast
So it has to be recreated every week
Could be easier to simply put 1 for present and 0 for absent, then calculate average and make it percent. However this method is more aesthetic.
Will look complicated when used for a month
Formula is what I cannot remember 😅
You can always press "fx" above the column numbers(as shown here) and type in the formula, everything will be listed after that ;)
Formula please
Office version????
Im not able to locate checkbox in insert
This is google sheet. Not excel
too fast I dont understand the formula
Very fast. You can slowly.
Modi hai to mumkin hai
Cant read the formula clearly
L
There is a list 😂
Does this also work in Excel?
No. All this stuff on RUclips now is for monetisation from views. Most of the videos don’t work on excel.
What version of excel is this?
Not excel . It's Google sheet
Formula looks like it might be =COUNTIF(C4:G4, TRUE)/COUNTA(C4:G4) so basically divide the number of checked boxes by the number of total boxes to her the percentage
Put formula in comments, it is bit hard to see formula, as it's going fast
it's a simple average?
What the top reply said.
Example: Attendance = 3, Works days = 5.
(3/5)100 = 60%
=COUNTIF (C4:G4, true)/COUNTA(C4:64). That is😅
thank you !
Do you have an easy way to track sick and vacation leave?
This is a google sheet not excel. In my experience you cannot insert a checkbox in excel this way.
Bro both r same thing, 70-80% features r same only somethings r different.
This work at google sheet . Not excel
Proxy becomes easy😂😂😂
Thanks
How did you do that? You still have to assign each checkbox in each cell.
Formula is what needs explanation yet there's none! I am sweating😅
Please put formula in comments.. It is very small and passing so quickly.
put the formula in comment cannot see it too fast
So it has to be recreated every week
Could be easier to simply put 1 for present and 0 for absent, then calculate average and make it percent. However this method is more aesthetic.
Will look complicated when used for a month
Formula is what I cannot remember 😅
You can always press "fx" above the column numbers(as shown here) and type in the formula, everything will be listed after that ;)
Formula please
Office version????
Im not able to locate checkbox in insert
This is google sheet. Not excel
too fast I dont understand the formula
Very fast. You can slowly.
Modi hai to mumkin hai
Cant read the formula clearly
L
There is a list 😂
Does this also work in Excel?
No. All this stuff on RUclips now is for monetisation from views. Most of the videos don’t work on excel.
What version of excel is this?
Not excel . It's Google sheet