Hello,
I want to format the value of a cell. For example:
I have a value of 1.25 in cell A1 and a value of 0.02 in cell A2. Now I want to add three asterisks (***) right behind 1.25 (that is 1.25***) and output 1.25*** in cell A3 if the value in A2 is less than 0.01. Similarly, if the value in A2 is between 0.01 and 0.05, add two asterisks; if the value in A2 is between 0.05 and 0.1, add one asterisk; if the value in A2 is greater than 0.1, no asterisk is added. So the output I want based on my example is 1.25**
Is it possible to write an if formula to achieve what I need? Such formula =if(A2<0.01,A1"***") does not work.
Another thought I have is to output asterisks only and combine cell value and asterisks. For example, I can have 1.25 in cell A1 and *** in cell A2. Can I use a formula to output 1.25*** in another cell by combining the content in cells A1 and A2?
Thank you.
Bookmarks