The '7' limit only applies to nested IFs. If you don't nest you can use
more, but there are almost always better ways to approach such a problem,
some of which other have suggested.

Cheers


"wuwu" wrote in message
...
Excel limits the function IF at 7 times, how can I set IF more than 7
times
in a cell
--
wuwu


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.788 / Virus Database: 533 - Release Date: 1/11/2004