| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
"If function" works in Excel 2000 but not in 2007
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| Need function that will work in Excel 2003 like "Countifs" in 2007 | Excel Worksheet Functions | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| Using "Find" function in Excel 2000, edit data without closing Fin | Excel Discussion (Misc queries) | |||
| Does Excel 2000 have the "List" data function like in Excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
