Need a formula to calculate cost per unit!

[huntsha]

Hello,

I'm working with an old report that someone else put together and need help modifying the formulas, validating and simplifying if possible.

What is missing or needs to be validated is the overtime. Below is the formula in its current state.

=IF(E5<=8,((E5*18.58)*1.33),IF(E5>=8,((((E5-8)*18.58)*1.5)+8*18.58)*1.33,(E5*18.58)*1.33))

I only need to calculate this monthly, not by day.

Example;

Total COR. % HRS. OT HRS. rate
267 11 4% 175.0 3.0 $6,387.90

Any helps is appreciated!

[Special-K]

Cant answer the question but the second = sign is not needed.

IF(E5<=8...,IF(E5>=8...

The second = cant happen since the first = will take precedence.
Remove the second = sign, its confusing.

What is E5 anyway?

[huntsha]

E5 is the cell reference. Thx