- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- How long "IF" can work? -help

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.

- Re: How long "IF" can work? -help posted by J.E. McGimpsey on Mon, 06 Oct 2003
- Re: How long "IF" can work? -help posted by Max on Tue, 7 Oct 2003