Results 1 to 2 of 2

Thread: concatenate function

  1. #1

    concatenate function

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Excel Version
    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)?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts