Quote:
|
Originally Posted by Catalin.B
Anyway, in a single cell you can use only 7 nested IF 's for all versions of excel.
|
Not in all versions - the limit was increased from 7 to 64 in Excel 2007. But using a look up of some description is definitely the preferred option here.
