Problems with multiple statements IF function (Excel 2003)

**Manupi** · 02-03-2008, 06:10 AM

Hi,
I'm trying to use IF function with multiple statements in Excel 2003. However, whenever I try I get the "The formula you typed contains an error message".
I've tried even copying and pasting the example provided in the very Excel help file: =IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F")))) (without changing any value or symbol) in a blank worksheet but even so I get the same error message.

I'd really appreciate your help, as I don't know what else to do. I've also tried by copying and pasting examples I've found in different web pages, but the result is the same

Thanks a lot,
Manupi

**VBA Noob** · 02-03-2008, 06:17 AM

Maybe

=IF(A2="","",LOOKUP(A2,{0,59,69,79,89},{"F","D","C","B","A"}))

VBA Noob

**Manupi** · 02-03-2008, 06:32 AM

Originally Posted by VBA Noob

Maybe

VBA Noob

It doesn't work either

Thanks for the try, anyway.

**VBA Noob** · 02-03-2008, 06:34 AM

It doesn't work either

The above comment isn't helpful if you want to find a solution.

Can you please explain why it doesn't work

VBA Noob

**Manupi** · 02-03-2008, 07:02 AM

Sorry, I get the same error message: "The formula you typed contains an error". I just copied and pasted your formula, without changing anything. Could it be that there's one argument missing?

**VBA Noob** · 02-03-2008, 08:37 AM

What happens if you type a simple if statement

=if(A1="","",A1)

Can you use any other forumlas

Have you tried to evaluate the formula (see link)

http://www.bettersolutions.com/excel...I320311912.htm

Are you sure you have xl 2003 could it be microsoft works ??

VBA Noob

**Manupi** · 02-14-2008, 01:00 PM

Originally Posted by VBA Noob

What happens if you type a simple if statement

Can you use any other forumlas

Have you tried to evaluate the formula (see link)

http://www.bettersolutions.com/excel...I320311912.htm

Are you sure you have xl 2003 could it be microsoft works ??

VBA Noob

Hi,
Yes, I've tried to do all this and it works with one single statement but not with multiple. I also have Open Office, and tried to do the function on it (again, copying and pasting the formula provided in the "Help" of the program itself) but I had the same problem. It only seems to work with one statement. It's very weird, isn't it?
And it's Excel 2003 (original Office cd).