View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default "If function" works in Excel 2000 but not in 2007

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.