IF THEN Functions

[kdegross]

Hi -- I am pretty sure this is a basic IF Then function question, just having a lapse!

I want to calculate the following...

If Cell A>40, Then the result should be ((Cell A-40)*23.25)
If it is not >40, Return 0.00

This is for a timesheet / overtime. Thanks!

[DonkeyOte]

either

=IF(A1>40,(A1-40)*23.25,0)

or

=MAX(0,A1-40)*23.25

[kdegross]

Thanks -- worked!