Howdy everyone,
In the excel file, have a look at the blue table and click on 'cell B9'.
There is an IF function with 7 other IF functions nested in it. Its purpose is to run through the cells A25 to A134 (but only the cells with a bolded frame), to check which one – there can only be one – has a value equal to 1, and to give as output the content of the cell that is next to the right of that cell.
Example:
If I call this function on B9, the cell in the range A25 to A134 whose value is equal to 1 is the cell A25 and, therefore, the output of the function is the letter ‘A’ (value of cell B25).
My question
The problem is that this function does not screen A25 to A134 but ‘only’ A25 to A67… This is because you can only nest a maximum of 7 functions within a function.
Does anybody know what I should do to solve this problem? I guess I would have to start writing a function in VBA or something like that… But the problem is I don’t know anything about that (crappy) language…
I send an S.O.S. to the world…
(Thanks anyway)
Xavier
Bookmarks