How long "IF" can work? -help

Giganews Newsgroups
Subject: How long "IF" can work? -help
Posted by:  Fawaz (afz20…@time.net.my)
Date: Mon, 6 Oct 2003

Hi,

I'm using the "IF" command to automatically set my
students gred from A,B+,B,C+,C,D, and F. It's all work
well until this semester the institution revises the
gredding scheme to A,A-,B+,B,B-,C+,C,C-,D+,D, and F.

My problem is that I can't seems to program more than 8 (9
if including the final arguments) but i need to be able to
put 11 arguments in the formula.

Is 9 the final limit of the "IF" command in Excel 2000?

How to overcome this problem and how about Excel 2002/XP?

If anybody can clarify this? thank you.

Fawaz,
Malaysia.

Replies