#### ashaari777

##### New Member

- Joined
- Oct 17, 2016

- Messages
- 10

I need some help please. this Formula not working ( the specified formula cannot be entered because it uses more levels of nesting than are allowed in the current file format )

do you have any idea to solve this .

=IF(H2:H2="401";"A";

IF(H2:H2="403";"B";

IF(H2:H2="408";"C";

IF(H2:H2="411";"D";

IF(H2:H2="412";"E";

IF(H2:H2="413";"F";

IF(H2:H2="416";"G";

IF(H2:H2="417";"H";

IF(H2:H2="418";"I";

IF(H2:H2="419";"J";

IF(H2:H2="420";"K";

IF(H2:H2="421";"L";

IF(H2:H2="424";"M";

IF(H2:H2="425";"N";

IF(H2:H2="427";"O";

IF(H2:H2="428";"P";

IF(H2:H2="429";"Q";

IF(H2:H2="430";"R";

IF(H2:H2="431";"S";

IF(H2:H2="434";"T";

IF(H2:H2="435";"U";

IF(H2:H2="438";"V";

IF(H2:H2="439";"W";

IF(H2:H2="440";"X";

IF(H2:H2="449";"Y"))))))))))))))))))))))))