Significance level in cells

Hi

I would like to add 1, 2, or 3 asterisks after a number in cell, depending on the value of the cell just aside (significance levels - 1 asterisk if the cell aside is < 0.1, 2 if < 0.05, 3 if < 0.01).

I tried cobining "if" and "concatenate", but the if supports only 1 option and not 3..

I checked older posts and it seems to me that the issue was only addressed for charts and graphs.

Thank you

If your value is in cell A1 then this should work:

=REPT("*",IFERROR(MATCH(A1,{0.1,0.05,0.01},-1),0))

It actually does!
Thank you very much!

For completeness..., then I guess I have just to combine it with CONCATENATE in order to attach the asterisk to the number as I was doing before (?).

CONCATENATE is generally a waste of letters, because everything it does can be done with a simple & ...

=A1 & REPT("*",IFERROR(MATCH(A1,{0.1,0.05,0.01},-1),0))

Great!
Thanks!