Why? Because the programmers didn't "teach" it how to do that. They provided
the CHOOSE, HLOOKUP, VLOOKUP, and LOOKUP, and MATCH functions which may solve
you problem if you describe what it is.

On Mon, 18 Apr 2005 21:25:01 -0700, "reneabesmer"
wrote:

why Microsoft Excel can't support if() function for thousands of mulitple
choice without VBA coding