Help with 'IF' Formula/Circular Ref Error MSG Pls

[carol01]

Hello,

I'm very new to excel as you will see! I am trying to work out a timesheet & am having some trouble with the IF statement.

I have a column for Overtime hours & Another for Time & Half which Im working on now. Overtime hours will be either calculated in
the time 1/2 or dbl time columns. The first 2 hours or under will need to be calculated to J12, time 1/2 but how can I do this?

=IF(I12<=2,I12,J12) This is the formula I have used but its muddled since Its returning an error as circular ref & it wont calculate now
when I subtract.

Overtime T1/2
4.00 2.00
2.30 2.00
0.60 0.60
0.00 0.00
3.00 0.00
8.30 2.00
using formual above.

thank-you