Solved greater than formula not working if equal too

May 24, 2014 at 05:32:41
Specs: Windows 7
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

See More: greater than formula not working if equal too

Report •

May 24, 2014 at 09:22:40
✔ Best Answer
Not sure what your looking for, but your formula


will only work if your hours are greater than 36 hours.

If you work exactly 36 hours or less then 36 hours,

then the formula returns what ever value is in C10

For 36 hours or greater try:


See if that works for you.


Report •

May 24, 2014 at 12:04:25
Many Thanks Mike, works like a charm :-)

Report •
Related Solutions

Ask Question