View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default 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