finally solved it using the IIF function


"Craig McLaughlin" wrote in message
...
I need a calculation to determine holiday pay.

I have the total hrs work*5.6/52 is the calcuation I use. HOWEVER if the
person works more than 39 hrs a week those hours have to be ignored.

So if someone worked say 50hrs how would I do the same calculation but
ignoring all hours worked beyond 39?

Thanks

Craig