View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default nested if function

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