Hola All, working on a overtime excel sheet for basic hours & over time. don't need clocking in & out just

total hours worked. anything over 36 hrs shows up as overtime amounts.all works great until i don't work overtime ie just 36 hrs then formula wont compute with the more than in the formula?? =IF(C10>36,B10*36,C10) works great if Boss wants me in but not on a flat week.

many thanks

Adam

Not sure what your looking for, but your formula =IF(C10>36,B10*36,C10)

will only work if your hours are

greater than36 hours.If you work

exactly36 hours or less then 36 hours,then the formula returns what ever value is in C10

For 36 hours or greater try:

=IF(C10=>36,B10*36,C10)

See if that works for you.

MIKE

Many Thanks Mike, works like a charm :-)

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History