Forum Discussion
HELP WITH FORMULA IF, AND
Hello - I am looking for basic excel formula help for an equation. What I need the cell to ultimately do is calculate overtime hours. So when I add the total hours (which are REGULAR + FACILITY + STB...
IF(MAX(A2-40,0)>40,MAX(A2-40,0),0)
Hope this help!
Hope this help!
THANK YOU! I had it in there earlier and tried it out for what I needed and I made an adjustment, but for some reason its not populating what i need again. The K (OT) column should be F-I-40. And then if its over 0 then generate that amount and under 0 then read 0.
Think you can give me one more shot on this??