Trouble with formulas

K

kevhatch

Hi,
I'm having trouble working out formulas for a weekly work hours sheet.
Everything was ok untill I added some extra columns to cover Bank Holidays.
If I work a B/H I get 8hrs standard pay, + 8hrs B/H pay, then anything above
that is double time. What I have so far works ok apart from the calculation
for double time.

I have posted a sample below.

http://www.flypicture.com?display=updone&id=rtv3kanb

I know how to remove the minus ( -1 spare cell, copy + paste
special.........) I just can't get the figures right in column "I" as you can
see!!
Any thoughts??
Thx
 
D

daddylonglegs

You just need to add some parentheses so that the subtraction takes
place before the multiplication, i.e. in I4

=IF(J4="",0,IF(J4=8,(D4-E4)*2))
 
K

kevhatch

Thanks very much... I see my mistake now! it is soooooo obvious I'm gonna go
beat my head against the wall.. lol (learning all the time!)
 
Top