Allen, I think I got it.

This is around the second query I asked in my previous post. You have set
R1C1 reference style for Excel 2007. **** Uncheck **** this option as below...

In XL2007: Office Button (left top button)Excel Options Formulas'Working
with formulas' R1C1 reference style

If this post helps click Yes
---------------
Jacob Skaria


"Allen" wrote:

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.