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
|