concatenate function

[sasha_1891]

I am using Excel 2007. I am calculating significance level and I would like to use a formula to calculate it automatically.
I have got the coefficient and the standard error in cell b7 and c7, so i use the following function:


=CONCATENATE(B7,SI(B7/C7>+-1.65," ",SI(B7/C7>+-1.96,"*",SI(B7/C7>+-2.58,"**","***"))))

The formula returns only the assigned symbols for positive number, but not for negative ones. Could you help me?

Thank you a lot.

[Bob Phillips]

Can you give a couple of examples of values in B7 and C7 that are wrong, and what they should be?

BTW, is your Excel a French Excel (I think it needs an extra function, and I want to supply the correct name)?