financial excel course london - Nested IF statement

Hi Liliana

There is a limit of 7 statements, however if you want to use more than 7 statements there is a way around, it is as follows.

You can create a defined name that refers to part of a formulae, so by having a number of defined names you can in fact use more than 7 if statements. So if you created 3 separate defined names called 1,2 and 3 which all refer to part of one large if statement, then you can have one overall if statement e.g.

=IF(1,2,3)

Hope this helps

David