if cell < than 0.05 then *

[cmendes]

Greetings,

If there a formula in which I can ask if the value of a particular cell is smaller then 0.05, 0.01 and 0.001 to generate "*", "**" or "***" respectively?
I have a excel table with all the p values and i would like to have the * for each one.
Thanks in advance,
C

 

[cmendes]

yes, it also works. I guess it might be better.
Thanks!
C

 

[Aladin Akyurek]

yes, it also works. I guess it might be better.
Thanks!
C

You are welcome. Thanks for providing us feedback.

 

[richarddec]

You guys are so quick at responding. Especially you Aladin! 46,973 posts and counting!