Sorry about that...

Cell BZ5 gets the hours. Cell BZ6 has the conditional statement
=IF(BZ540,BZ5-40). I then need cell BZ5 to change to 40 hours. I tried
using and in the then portion of the statement but it didn't work - Something
like =IF(BZ540,BZ5-40 and Bz5=40).

"Karen53" wrote:

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,