On Mon, 17 Oct 2005 17:40:05 -0700, "JimB"
wrote:

Do you know of any of creating formulas using the "if" function more than
seven times. It is normally limited to seven, I need as many as 20

99/100 when this question is asked, the best solution is a lookup table.

Look at HELP for the VLOOKUP function, and/or post back with more details.


--ron