|Subject:||How long "IF" can work? -help|
|Posted by:||Fawaz (afz20…@time.net.my)|
|Date:||Mon, 6 Oct 2003|
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.