Nested Functions

[Pschyrembel]

Hello All

I am trying to create a comprehensive spreadsheet and came across a problem.
I am would like to have Excel calculating lunch breaks within a more complex Function. Please see the function below.

The first part works a treat, however, the second part gives me headache. If the first part returns TRUE, I would like to Calculate the equation and deduct 0.5 for a luncgh break but only if the sum of the equation is greater then 6. I hope that makes sense and someone can help.

=IF(OR(C5="A/L",C5="S/L",C5="D/O",C5="B/H",C5="S/D"),7.5,IF(C5-C4<=6,SUM(C5-C4-0.5,SUM(C5-C6))))

Thank you for any attempts.

Frank

[Fotis1991]

Hi

=IF(OR(C5="A/L",C5="S/L",C5="D/O",C5="B/H",C5="S/D"),7.5,IF(C5-C4<=6,SUM(C5-C4-0.5,SUM(C5-C6))))

Frank, in your formula you show to us that in C5 you have Text values. Then in your second part you use IF(C5-C6.....

Can you upload a small sample workbook,pls?

[Pschyrembel]

It just clicked into place and I found the solution. I missed a bracket (How pathetic)
Thank you Fotis