Check your list separator in your Windows Regional settings (via Control Panel)
It should be a comma or semicolon, probably is a space now
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
| It seems to me that all formulas are giving problems.
|
| I just tried something simple.
|
| Select autosum
| select 3 cells
| pres CRTL
| select an other 3 cell but in different row .
| this is what the formula gives me
| =SUM(X42:AB42 R44:V44)
| but it results in #null
| now when I change this to
| =SUM(X42:AB42 : R44:V44)
| it works ?
| So why isn't the ":" inbetween the 2 selections of cells ?
|
|
| the error I'm getting on the
| =if(A6=6 1 0)
| is
|
| the formula you typed contains an error .....etc..
|
| Strangly enough I tried it via the Function wizard so didn't key in anything
| but the requested field ?
|
|
| Hope you can help otherwise I need to reinstall Office completly and see
| what it gives ? And hope it works .
|
|
|
| "Niek Otten" wrote:
|
| > What error do you get?
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | Pete ,
| > |
| > | It still doesn't work .
| > | Why is the function wizard giving me the formula without the "," or ";" ?
| > |
| > |
| > | "Pete_UK" wrote:
| > |
| > | > You normally have a comma or semi-colon between the parameters,
| > | > depending on your regional settings, so try this:
| > | >
| > | > =if(A6=6,1,0)
| > | > or this:
| > | > =if(A6=6;1;0)
| > | >
| > | > Hope this helps.
| > | >
| > | > Pete
| > | >
| > | > On Nov 20, 9:09 am, Ingenious <
[email protected]>
| > | > wrote:
| > | > > I seem to have a strange problem with Excel 2007 .
| > | > > I have a simple formula but it doesn't work .
| > | > >
| > | > > =if(A6=6 1 0)
| > | > >
| > | > > When I get a xls 2003 worksheet with this formula it works fine.
| > | > > When I now try and change the formula to
| > | > > =if(A6<6 1 0)
| > | > > Excel 2007 comes up with a problem in the formula .
| > | > > SO I used the function wizard to inseret the IF statement and there it
| > | > > allows me to key in all the fields but as soon as I want to confirm the error
| > | > > comes up again?
| > | > > Does anyone have the same problem ?
| > | >
| > | >
| >
| >
| >