Home/ Questions/Q 14275
Next
Answered
computing
  • 10
Asked: 2021-12-14T23:25:15+00:00 In:

Solved Greater Than Formula Not Working If Equal Too

  • 10

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

Share

    1 Answer

    1. Best Answer
      Not sure what your looking for, but your formula

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

      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:

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

      See if that works for you.

      MIKE

      http://www.skeptic.com/

      • 0