Formula questioin
 

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,

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,

Hi
Do you mean something like this in E2?
=IF(F2=BZ5-40,40,0)

Andy.

"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,

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,

Hi
I think you'll have to use another cell to register whether BZ5 was over 40
or not - otherwise you'd have to use VBA, I reckon. If you give us a bit
more info, like what you are trying to achieve and the other info you're
wokring with, it might be a bit easier to advise on where to go!!

Andy.

"Karen53" wrote in message
...
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,