IF_ISNUMBER_FIND 2

Multiple functions - more than 7 functions

How to nest more than six =IF(ISNUMBER(FIND functions, in five steps.

First, write the initial macro string thus :-

=IF(ISNUMBER(FIND("one",A1,1)),101,IF(ISNUMBER(FIND("two",A1,1)),102,IF(ISNUMBER(FIND("three",A1,1)),103,IF(ISNUMBER(FIND("four",A1,1)),104,IF(ISNUMBER(FIND("five",A1,1)),105,IF(ISNUMBER(FIND("six",A1,1)),106,0))))))

Second, in the Name box give it a name - say Number1

Third, write the extended macro string thus :-

=IF(ISNUMBER(FIND("seven",A1,1)),107,IF(ISNUMBER(FIND("eight",A1,1)),108,IF(ISNUMBER(FIND("nine",A1,1)),109,IF(ISNUMBER(FIND("ten",A1,1)),110,IF(ISNUMBER(FIND("eleven",A1,1)),111,IF(ISNUMBER(FIND("twelve",A1,1)),112,0))))))

Fourth, in the Name box give it a name - say Number2

Fifth, link the two macro strings thus:-

=IF(Number1,Number1,Number2)