| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error in cell formula
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula error - cell reference | Excel Discussion (Misc queries) | |||
| Error putting a formula in a cell with vba | Excel Programming | |||
| error in one cell and formula in other | Excel Worksheet Functions | |||
| Formula expected end of statement error, typing formula into cell as part of VBA macro | Excel Programming | |||
| How to set a formula in a cell? Application-defined error. | Excel Programming | |||
Threaded Mode
