On Wed, 25 Jan 2006 10:51:02 -0800, "Shannon"
wrote:

Is there a limit to the number of logical IF-THEN statements you can use in
one cell? I'm trying to use 12 in one cell. If there is a limit, is there a
work around?

As noted in other posts, the limit is 7. A non-VBA workaround can be
found he

http://www.cpearson.com/excel/nested.htm

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *