iotapsi321
New Member
- Joined
- Oct 6, 2017
- Messages
- 22
Hello. I am wondering how I would add an asterisk to numbers in column A only if the numbers in column B is in between two values? Thanks in advance for your time!
That’s the basic question. I’m creating a stats table and need to add one asterisk if a value is in between .05 and .011; I would add two asterisks if the value is in between .01 and .0011; and a third asterisk if the values are equal to or less than .001.
Here is what I am hoping to accomplish.
Column A Column B Column C
.56. .05 .56*
.73. .001. .73***
.02. .86. .02
.46. .06. .46
.68. .01. .68**
That’s the basic question. I’m creating a stats table and need to add one asterisk if a value is in between .05 and .011; I would add two asterisks if the value is in between .01 and .0011; and a third asterisk if the values are equal to or less than .001.
Here is what I am hoping to accomplish.
Column A Column B Column C
.56. .05 .56*
.73. .001. .73***
.02. .86. .02
.46. .06. .46
.68. .01. .68**
