Return specific formula based on information

[shorie7]

Hi all,

Need a little help here, I've tried and failed miserably.

Here's my problem.

My girlfriend needs a time schedule sheet for work.

The problem is this...

If she works half an hour she gets paid £10 per half.
If she works over half hour it becomes £16 per hour.

In columns B and C, I put the start and end times of work, formatted to "TIME", and in column F, I have a formula to multiply the work hours from column E, based on its value (multiply by £10 if half hour, by £16 if an hour)...and add the total for that week in F14.

I can't for the life of me however, find out how to return "zero" in column F if there's no start or end times entered in B and C.

It keeps returning £10....

Obviously then, the end of week balance (F14), is showing as £76...instead of only £26, as the other days when she DIDN'T work, still show a value of £10....when I want it to return zero....

Hope this makes sense.

I've been trying for 3 hours already but just can't crack it.

Any suggestions would be appreciated.

Workbook uploaded.

[Sam Capricci]

maybe =IF(E7=0,"",IF(E7>0.5, (E7*16), IF(E7<0.98, (10*1), 0)))

[Sam Capricci]

another option is =IF(E7=0,0,IF(E7>0.5, (E7*16), IF(E7<0.98, (10*1), 0)))
the reason it was returning 10 is because your last argument "IF(E7<0.98,(10*1)" (by the way this would be the same IF(E7<0.98,10,0) )
but that last argument is saying anything less than 0.98, return 10, well the value of zero in E7 is less than 0.98 so that is why you were getting the 10.

If statements work in order of what they find going from left to right and so the first argument it finds that fulfills the IF statement that is the one it takes.

=IF(E7=0,0,IF(E7>0.5, (E7*16), IF(E7<0.98,10, 0))) would give you the same. Multiplying 10 by 1 just gives you 10.