Functions not working in Excel XP

[Stoffel24]

Hi

I have a peculiar error. On one pc that is brand new and has just had all its software loaded, when I type in a formula such as =IF(SUM(A1:A3) = 6, "Yes", "No&quot, I get an error message saying there is a problem with this formula. Cells A1 through A3 contain regular numbers (1,2, 3). On other PC's I have no trouble at all. Is there a setting in XP where you can disable formulas? I have checked the archives and no one else seems to have had this problem. We could reinstall but I was kinda curious and this may not solve the problem.

Thanks

 

[PepeLeMokko]

Use semi-coloms ( instead of commas in your formula, and there you go
:-D

 

[Stoffel24]

Ok, that doesn't work. I have worked on it a bit more. It seems to be related to if statements. Other functions such as Sum(A1:A5) work fine. If you do an "=if(...)" or "ifsum(...)" then you get a problem. If you add the conditional sum option from addins, and use the wizard, the formula works. But if you go into the formula and change the location of one of the referenced cells, then the formula falls over once again. It is very bizarre.

Thanks

 

[KenWright]

What happens if you create a file with a working statement on a machine that is OK, save the file down and then open it on this new machine?

Regards
Ken................

 

[Stoffel24]

We have reinstalled Office XP and added all the service packs. But we still have this problem. If you open a file created elsewhere, you see the correct results. If you refresh the calculations (F9), there is still no problem. However, as soon as you click on the cell with the if function in it (even if you make no changes), you get an error message. We are all baffled. Mallet anyone?

 

[combo]

What happens when you write =SUM(A1,A2,A3)? In case of error there is a problem with list separator (control panel>international>numbers). Also, check settings in excel separators for numbers (tools>options>international).

combo

 

[KenWright]

I'm with Combo on this one. Would be interesting to have you post the exact formula, copied from the cell (Not typed, but copied and pasted into the note), from the file on a pc that works, and then from the same cell on the new pc once you have opened that file successfully on it.

Regards
Ken..............