If / then statements with subtraction problem
I was hoping some of the pro's on here could help me figure something out. I'm creating a hours tracker for employees to use remotely and I need to calculate the overtime hours as anything over 8 or anything over 10 depending on the answer given in a column.
So if [certified] = "Yes" then subtract 8 from [total hours] = OT Hours
if [Certified] = "No" then subtract 10 from [total hours] = OT Hours
It should look like this once done
I was trying to do something like
if ([Certified]@row = "Yes") -8 Value([Total Hours]@Row)
if ([Certified]@Row = "No") -10 Value([Total Hours]@Row)
I'm sure there could be more logical ways of doing this however I'm pretty new and am trying to keep this as simple as possible while I learn. I appreciate any and all feedback.
Help Article Resources
Check out the Formula Handbook template!