Karen,

Can you explain the conditions of E2 a little more? This is a little
confusing. What is the requirement here exactly?

--
Regards,
Zack Barresse, aka firefytr

"Karen53" wrote in message
...
Hi,

Cell E2 gets the hours. Cell F2 has the conditional statement
=IF(BZ540,BZ5-40). I then need cell E2 to change to 40 hours. Is there
a
way I can do this?

Thanks,