sasha_1891
New member
- Joined
- Jul 23, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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.
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.