Mon Tue Wed Thu Fri
8 8 2 0 0
=(COUNTIF(L11:BF11,"0")-COUNTIF(L11:BF11,"=5"))+((COUNTIF(L11:BF11,"=5")-COUNTIF(L11:BF11,"=8"))/2)

The formula returs 1 But now i need to return 0
Regards
YM



"Yitzhack" wrote:

what it needds to return is if 0 = 1 the current formula returns if then 5
= .5.
BAsicaly what i need is if L9 is 0 = 1 if is than 0 but< than5 = 1 if than
5 but <than 8 = .05.
If you miss up to 3 hours out of 8 = .05
if you miss full day = 1
If you miss more than 3 = 1
--
Regards
YM



"Thomas [PBD]" wrote:

Yitzhack,

Could you give me the example data? L9:BF9
Secondly, what is it that you would like to happen? Would you just like to
include 0 into the formula? You could change that with "=0" in the first
COUNTIF. I could be mistaken. In all essence, what would you like the
formula to return?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Yitzhack" wrote:

Good morning all. I'm currently working on a attendance tracker, I have a
formula that will give us either half or full occurrence. Before we didnt
need to track 0 but now we have. I tried to change the formula to give us a
full occurrence (1) but Im getting an error. Can anyone help me with this€¦
Thanks

=(COUNTIF(L9:BF9,"0")-COUNTIF(L9:BF9,"=5"))+((COUNTIF(L9:BF9,"=5")-COUNTIF(L9:BF9,"=8"))/2)


--
Regards
YM