I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little .
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Hi Louise,

What is your formula and what error message do you get?

--
Kind regards,

Niek Otten

"Louise" wrote in message
...
I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little
.
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same
formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

It simply says 'the formula you typed contains an error. For more
information on formulas, click onto help'??

The formula i am trying to enter is:-

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340," D","U"))))

It is when I try to enter the four sets of brackets at the end that the
error occurs??
Any ideas?
Thanks again, Louise.

"Niek Otten" wrote:

Hi Louise,

What is your formula and what error message do you get?

--
Kind regards,

Niek Otten

"Louise" wrote in message
...
I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little
.
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same
formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Your formula works for me, so I assume Ron is correct.
Try entering a simple function with the function wizard and see if it
generates commas or semicolons

--
Kind regards,

Niek Otten

"Louise" wrote in message
...
It simply says 'the formula you typed contains an error. For more
information on formulas, click onto help'??

The formula i am trying to enter is:-

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340," D","U"))))

It is when I try to enter the four sets of brackets at the end that the
error occurs??
Any ideas?
Thanks again, Louise.

"Niek Otten" wrote:

Hi Louise,

What is your formula and what error message do you get?

--
Kind regards,

Niek Otten

"Louise" wrote in message
...
I am trying to create a nested IF function (has 5 IF statements),
however,
every time I put the brackets at the end of the function, it puts a
little
.
next to the false answer, removes the brackets and comes up with an
error
message??

This is only happening on one particular PC, when I create the same
formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

I have checked the Regional Settings and it is in fact set to a comma as a
separator which is correct. Where do I go from here?????

Thanks again.

Louise

"Niek Otten" wrote:

Your formula works for me, so I assume Ron is correct.
Try entering a simple function with the function wizard and see if it
generates commas or semicolons

--
Kind regards,

Niek Otten

"Louise" wrote in message
...
It simply says 'the formula you typed contains an error. For more
information on formulas, click onto help'??

The formula i am trying to enter is:-

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340," D","U"))))

It is when I try to enter the four sets of brackets at the end that the
error occurs??
Any ideas?
Thanks again, Louise.

"Niek Otten" wrote:

Hi Louise,

What is your formula and what error message do you get?

--
Kind regards,

Niek Otten

"Louise" wrote in message
...
I am trying to create a nested IF function (has 5 IF statements),
however,
every time I put the brackets at the end of the function, it puts a
little
.
next to the false answer, removes the brackets and comes up with an
error
message??

This is only happening on one particular PC, when I create the same
formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

On Thu, 1 Dec 2005 03:20:01 -0800, Louise
wrote:

I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little .
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Could it be a regional settings difference? (Start/Control Panel/Regional and
Language settings). Some use a semicolon for a separator vs a comma.

If not, post your formula and sample data inputs and expected outputs.


--ron

Thanks for your reply.
I've been into the Regional Settings and can't find anyhthing relating to
using commas as separators?? Where are they??

Below is the formula I am using - it works fine on all other PC's, except
this one??

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340," D","U"))))

It is basicall calcualting the score for students, obviously the higher the
score, the better the grade. When I try to enter the four sets of brackets
at the end, that's where the error appears.

Thanks again.

"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 03:20:01 -0800, Louise
wrote:

I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little .
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Could it be a regional settings difference? (Start/Control Panel/Regional and
Language settings). Some use a semicolon for a separator vs a comma.

If not, post your formula and sample data inputs and expected outputs.


--ron

On Thu, 1 Dec 2005 05:47:03 -0800, Louise
wrote:

Thanks for your reply.
I've been into the Regional Settings and can't find anyhthing relating to
using commas as separators?? Where are they??

There's a customize button next to the language name; and on the numbers tab
there is an option for "list separator".


Below is the formula I am using - it works fine on all other PC's, except
this one??

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340, "D","U"))))

It is basicall calcualting the score for students, obviously the higher the
score, the better the grade. When I try to enter the four sets of brackets
at the end, that's where the error appears.

Describe again the error message. All I've read is that a dot appears, but I'm
not sure where, and/or if there are any other messages.

Also, what version of Excel is being used on the errant machine, vs the
functioning ones? Is it a non-US version?




Thanks again.

"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 03:20:01 -0800, Louise
wrote:

I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little .
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Could it be a regional settings difference? (Start/Control Panel/Regional and
Language settings). Some use a semicolon for a separator vs a comma.

If not, post your formula and sample data inputs and expected outputs.


--ron


--ron

Ron

The error message says:- 'the formula you typed contains an error. For more
information on formulas, click onto help'??

The formula i am trying to enter is:-

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340," D","U"))))

It is when I try to enter the four sets of brackets at the end that the
error occurs?? Again, on any other PC it works fine, it's just this one.

Office XP is installed on all PC's.
Thanks again.
Louise


"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 05:47:03 -0800, Louise
wrote:

Thanks for your reply.
I've been into the Regional Settings and can't find anyhthing relating to
using commas as separators?? Where are they??

There's a customize button next to the language name; and on the numbers tab
there is an option for "list separator".


Below is the formula I am using - it works fine on all other PC's, except
this one??

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340, "D","U"))))

It is basicall calcualting the score for students, obviously the higher the
score, the better the grade. When I try to enter the four sets of brackets
at the end, that's where the error appears.

Describe again the error message. All I've read is that a dot appears, but I'm
not sure where, and/or if there are any other messages.

Also, what version of Excel is being used on the errant machine, vs the
functioning ones? Is it a non-US version?




Thanks again.

"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 03:20:01 -0800, Louise
wrote:

I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little .
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Could it be a regional settings difference? (Start/Control Panel/Regional and
Language settings). Some use a semicolon for a separator vs a comma.

If not, post your formula and sample data inputs and expected outputs.


--ron


--ron

What happens with simpler formulas?

e.g.: =IF(I380,"A","U")

If you don't get the error with the simpler formula, then possibly you have a
typo when you are typing in the formula.

--ron


On Fri, 2 Dec 2005 00:46:02 -0800, Louise
wrote:

Ron

The error message says:- 'the formula you typed contains an error. For more
information on formulas, click onto help'??

The formula i am trying to enter is:-

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340, "D","U"))))

It is when I try to enter the four sets of brackets at the end that the
error occurs?? Again, on any other PC it works fine, it's just this one.

Office XP is installed on all PC's.
Thanks again.
Louise


"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 05:47:03 -0800, Louise
wrote:

Thanks for your reply.
I've been into the Regional Settings and can't find anyhthing relating to
using commas as separators?? Where are they??

There's a customize button next to the language name; and on the numbers tab
there is an option for "list separator".


Below is the formula I am using - it works fine on all other PC's, except
this one??

=IF(I380,"A",IF(I370,"B",IF(I360,"C",IF(I340, "D","U"))))

It is basicall calcualting the score for students, obviously the higher the
score, the better the grade. When I try to enter the four sets of brackets
at the end, that's where the error appears.

Describe again the error message. All I've read is that a dot appears, but I'm
not sure where, and/or if there are any other messages.

Also, what version of Excel is being used on the errant machine, vs the
functioning ones? Is it a non-US version?




Thanks again.

"Ron Rosenfeld" wrote:

On Thu, 1 Dec 2005 03:20:01 -0800, Louise
wrote:

I am trying to create a nested IF function (has 5 IF statements), however,
every time I put the brackets at the end of the function, it puts a little .
next to the false answer, removes the brackets and comes up with an error
message??

This is only happening on one particular PC, when I create the same formula
on other pC's, it works fine so I know my formula is correct.

is there a setting on the PC that must be wrong???

Help.....!!

Thank you

Louise

Could it be a regional settings difference? (Start/Control Panel/Regional and
Language settings). Some use a semicolon for a separator vs a comma.

If not, post your formula and sample data inputs and expected outputs.


--ron


--ron


--ron