Error in cell formula
first there 9is a limit of 8 nested IF's in excel. You have 9. Second, in
USA the semicolons should be commas.
I would use lookup instead
=LOOKUP(LEFT(C86,3),{"0","406","729","732","733"," 734","735","736";"","124","551","551","552","552", "553",""})
"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
|