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, 1 views)

The If formula has three parts: Test,ValueIfTrue,ValueIfFalse. You only provided a ValueIfTrue so when the False state is triggered you didn't tell the formula what to do. That is fixed by adding that to the formula in cell F6
=IF(H6>=7.6,7.6,H6)

But I would use a simpler formula in cell F6 and then copy it down
=MIN(7.6,H6)
That will give you the actual hours up to a maximum of 7.6

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Hi Andrew,

Thank you so much for helping me out, if I get stuck again Ill just shout out.

Thanks
Tash