L
laandmc
How do you if you’re referencing a cell in the middle of txt set the amount
of decimal places it uses.
Example
a b
1 average 41.333333 days 41.3
Cell A1 has the function: =â€average â€&B1&†daysâ€
B1 actual value is 41.333333 with a format of 1dp.
I want to get the outcome
a b
1 average 41.3 days 41.3
Is there a way to do this.
of decimal places it uses.
Example
a b
1 average 41.333333 days 41.3
Cell A1 has the function: =â€average â€&B1&†daysâ€
B1 actual value is 41.333333 with a format of 1dp.
I want to get the outcome
a b
1 average 41.3 days 41.3
Is there a way to do this.