Sorry forgot to add my version of Excel use , compared to your ; so you will
need to change it.

Mike

"Jerry Manner" wrote:

Hi

Almost whole day I am struggling with cell formula below.

=IF(OR(LEFT(C86;3)="729";LEFT(C86;3)="732");"551"; IF(OR(LEFT(C86;3)="803";LEFT(C86;3)="733";LEFT(C86 ;3)="734");"552";IF(OR(LEFT(C86;3)="740";LEFT(C86; 3)="824");"770";IF(OR(LEFT(C86;3)="736";LEFT(C86;3 )="735");"553";IF(LEFT(C86;3)="804";"773";IF(LEFT( C86;3)="737";"770";IF(LEFT(C86;3)="406";"124";IF(C 40(C86;3)="738";"775";""))))))))

If I click the enter button I get a MS excel error message telling me
that the formula you typed contains an error. I have double checked
the formula for hours, counted the open and closing bracket. I cannot
find the error in the formula.

I hope that someone else with a fresh look can quickly see the
problem.

Regards