Hi Everyone,

I need help please. I want to add a formula but not sure how to do it, i googled but its not giving me the info I need.

in our timesheet excel i have made i want to ad the following:

1. IF the employee worked 8 hours the value should be 7.6 (if its less it should show what the value is) I got the 1st part but not the second it just gives me the word FALSE

2. IF it is 8 hour (7.6) then he should get 0.4 is it is not 8 then is should be 0

So basically what I want it to do is the following:

If you worked 8 hours then it is 7.6 + 0.4 = 8
if you worked less than 8 hours it is jut 7.6 + 0 = 7.6

I don't know how to do this in excel.

Please see attached what i have done.

Thanks


Tash

Attached Files

Help .xlsx (13.7 KB, 3 views)