Hello all, I hope someone can help me with this problem I have - I've tried various methods but can't seem to work this out.
Cell A1 is a formula that calculates a figure to 2 significant digits. In cell A2, there is another number which needs to be one more decimal place than the number in A1. For example, if A1 = 1.05 , A2 needs to be 3.058. Similarly, if A1 = 5.0, A2 needs to be 3.35.
The actual number calculated in A1 could be anything, so I can't really use set conditional formatting. Is there a formula or method that I can use to achieve this? I would be open to using Visual Basic if necessary. Thanks in advance.
Cell A1 is a formula that calculates a figure to 2 significant digits. In cell A2, there is another number which needs to be one more decimal place than the number in A1. For example, if A1 = 1.05 , A2 needs to be 3.058. Similarly, if A1 = 5.0, A2 needs to be 3.35.
The actual number calculated in A1 could be anything, so I can't really use set conditional formatting. Is there a formula or method that I can use to achieve this? I would be open to using Visual Basic if necessary. Thanks in advance.
