I need a cell to =5 always, unless the days are more than 5 then sum (max 7)
I am calculating Per Diem Days. Right now I use =COUNTIF(G111:M111,”>0″) for all employees, there is one employee who is paid 5 no matter days worked unless he more than 5 with a max of 7 days in the week. I am not sure what formula I should use.
I am calculating Per Diem Days. Right now I use =COUNTIF(G111:M111,”>0″) for all employees, there is one employee who is paid 5 no matter days worked unless he more than 5 with a max of 7 days in the week. I am not sure what formula I should use. Read More
