Jerry,

It's nested too deeply, use vlookup instead.
Build a table like this ones, I think I've got all your conditions correct
but check it.
Note my table is in A828:B840 bit it could be anywhere
729 552
732 552
803 552
733 552
734 552
740 770
824 770
736 553
735 553
804 773
737 770
406 124
738 775

Then use this formula
=VLOOKUP(LEFT(C863,3)+0,A828:B840,2,FALSE)


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