Give us more details of what you want to do. There are ways of
combining IFs to overcome the 7-nested limits, but there are also
other ways of coping with multiple choices which don't involve IF.

Pete

On May 6, 10:00*pm, pierre wrote:
we all know that *IF function *is limited to 7 conditions.
what should i do if i have 15 conditions ? and how to insert them in one
single formula ?

THANKS FOR YOUR HELP