Yes I am sure it is Excel 2007. It came pre-installed by Dell. I will try
contacting them too.

No the PC with 2007 does not also have 2000 installed. They are 2 seperate
PCs.

R1C1 cell reference format was not checked. I tried checking it, same
result. Changed it back to A1 format.

This particular formula is one from the help topic. I was using it to what
I was doing wrong (keep it basic until I could see what I was doing wrong).

The error is related to all forms of If functions regardless of the figures,
location in the sheet, new or previously created sheets. Same result if I
enter the formula myself or use the Insert Function Wizard.

More bad news. I am getting errors with other logical functions: OR, AND.

The help text used commas to seperate the logical tests, but the function
wizard does not. Related?

"Ashish Mathur" wrote:

Hi,

=IF(A110,"Over 10","10 or less")

This formula seems correct. Is this a part of a larger formula?

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Allen" wrote in message
...
Any "If functions" {Example: =IF(A110,"Over 10","10 or less")} are not
working for me in Excel 2007. They work fine in 2000 but in 2007 this
error
appears, "The formula you typed contains an error". The first 10, is
highlighted suggesting the problem is there.
The cells are general format, not text. Office service pack 3 installed.
Running Vista.
Got any hints folks?
Thanks in advance.