Error in cell formula
Try to use comma as argument separator! Original English function names
require comma, some national language versions use semicolon, but in this
case function names are also translated.
Regards,
Stefi
€˛Jerry Manner€¯ ezt Ć*rta:
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
|