nested if function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
Click to expand...

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(I3>80,"A",IF(I3>70,"B",IF(I3>60,"C",IF(I3>40,"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.
 
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(I3>80,"A",IF(I3>70,"B",IF(I3>60,"C",IF(I3>40,"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.
 
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
 
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
 
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??
Click to expand...

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(I3>80,"A",IF(I3>70,"B",IF(I3>60,"C",IF(I3>40,"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.
Click to expand...

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.
Click to expand...

--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(I3>80,"A",IF(I3>70,"B",IF(I3>60,"C",IF(I3>40,"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
 
What happens with simpler formulas?

e.g.: =IF(I3>80,"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


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(I3>80,"A",IF(I3>70,"B",IF(I3>60,"C",IF(I3>40,"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
Click to expand...

--ron
 
I copied your formule into my version of Excel (2003 dutch), replace
the IF with our dutch equivalent ALS and since my list separator i
also a comma it worked fine.

I think your problem with that particular PC is the list separator, tr
the semi-colon ; and see if you get the same error.

You can also try like somebody else said enter the formula in a simpl
manner
=IF(I3>40,"A","F")

Another option is to emty the cell and redefine the format.

The retype the formula, do NOT copy an paste.

Good luck,

Han
 
it works fine with simple formulas.
there isn't a typo on the formula, i've checked it a dozen times and even
got a colleague to do it as well, to see if they get the same result.
 
Hello, thank you for your reply.

I have tried using the ; as the list separator and I get the same error. I
have checked the Regional Settings of the PC and this is set to a comma. It
isn't just that one particular worksheet that this formula doesn't work,
whichever workbook I am using, it will not let me create a nested IF
statement without coming up with the same error.

I cannot use the formula you have suggested below as this is for exam
results so, depending on the score the student achieves, depends on the Grade
they get.

Louise
 
Just to complicate this even further.........

I have e-mailed the worksheet from the 'problem pc' to my own pc and when I
then enter the formula, it works fine. It must be something to do with the
settings on that pc but I don't know what.........

Louise
 
Do you have an autocorrect option for 4 closing brackets?

Check Tools<Autocorrect options
 
GENIUS!!!! I never thought of that!!!

Somebody had added an AutoCorrect that changed closing brackets into the
telephone symbol!??!?!?!

Thank you so much, this has bugged me since yesterday.

merry Christmas.
 
GENIUS!!!! I never thought of that!!!

Somebody had added an AutoCorrect that changed closing brackets into the
telephone symbol!??!?!?!

Thank you so much, this has bugged me since yesterday.

merry Christmas.
Click to expand...


Great.

And if we had read your first post more literally, one of us might of guessed
this answer earlier:

every time I put the brackets at the end of the function,
Click to expand...
--> it puts a little . next to the false answer, removes the brackets <--
Click to expand...
and comes up with an error message??
Click to expand...


--ron
 
<And if we had read your first post more literally, one of us might of
guessed this answer earlier:>

Absolutely! In hindsight I don't understand why we didn't see it at once.
Louise literally wrote about characters changing and from the description I
understood that the change happened before Enter was hit.
Anyway, kept us busy for a day!
 
Back
Top