See this:

http://j-walk.com/ss/excel/usertips/tip080.htm

Note the concatenate method. Although it's possible, it should be your
*LAST* option.

Biff

"pandurrr" wrote in message
...

Hellow friend,

There is a limitation of 7 (Seven) levels for Nested function ( IF
function)
in Microsoft Excel .

Will you please let me know, how to increase this nesting limit of 'IF'
function upto 9 or 10 levels, so that I can use the facility for my
requirement.

Will you please help me in this and provide me the solution to

regards

redishetti