| 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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"If function" works in Excel 2000 but not in 2007
Hi Allen
--Is 2000 installed in the same PC...? --Does any other formula work in the latest version of Excel? --Are you sure you are using MSExcel 2007 for Windows or Excel2008 for Mac =IF(A110;"Over 10";"10 or less") 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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"If function" works in Excel 2000 but not in 2007
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"If function" works in Excel 2000 but not in 2007
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. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"If function" works in Excel 2000 but not in 2007
Hi Allen
Did you try the formula I pasted in the first response..Try out the below. The argument separator use by Excel is taken from the regional setting of your Windows installation. The below steps are for XP but I am sure you should be able to identify this with ease --Goto Windows StartSettingsControl Panel --From the list click on 'Regional and Language Options' --Click on 'Customize' button to open 'Customize Regional Options' --Check the 'List separator'. This is used by Excel for separating arguments. Is that ;. Change to suit.. If this post helps click Yes --------------- Jacob Skaria "Allen" wrote: 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. |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"If function" works in Excel 2000 but not in 2007
On Fri, 9 Oct 2009 21:48:01 -0700, 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. Check Start/Control Panel/Windows Regional Settings. I'll bet you have your system settings to be using a delimiter OTHER than a comma. OR Try replacing the commas with semicolons within the function. --ron |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"If function" works in Excel 2000 but not in 2007
That's it!
The list seperator was set to space instead of comma. Problem Solved. Thanks everyone. Allen "Ron Rosenfeld" wrote: On Fri, 9 Oct 2009 21:48:01 -0700, 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. Check Start/Control Panel/Windows Regional Settings. I'll bet you have your system settings to be using a delimiter OTHER than a comma. OR Try replacing the commas with semicolons within the function. --ron |
| Reply |
| 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) | |||
Linear Mode
