nested if function
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
|