Re: Excel 2007 Formula problem .
- From: Pete_UK <pashurst@xxxxxxxxxxx>
- Date: Tue, 20 Nov 2007 01:40:04 -0800 (PST)
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 <Ingeni...@xxxxxxxxxxxxxxxxxxxxxxxxx>
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 ?
.
- Prev by Date: Re: Unable to add/delete row
- Next by Date: Re: Counting Unique Data
- Previous by thread: Unable to add/delete row
- Next by thread: Re: Excel 2007 Formula problem .
- Index(es):
Relevant Pages
|
