CALC.
I have two cells (A1 and A2); their values are:
A1: 0,1
A2: 12,34567
I want the second cell to be rounded with base showed in the first cell. So i write in A3:
A3: =mround(A2;A1)
and the value shown in A3 is 12,30. Perfect!
Now I’d like to automatically format the number in A3 with the value written in A1. So the result should be 12,3.
Varying A1 will automatically change the format of A3. For example, if i write in A1 0,001 I should read in A3 12,345.
thank you!