Alternatively, you could check the Tools/Options/Calculation/Precision
as displayed checkbox. This will apply to the entire workbook, however.

In article ,
"Anne Troy" wrote:

Then you must make the value the same as the format. For instance, if 8.6 is
in A1, you would have to put:
=round(a1,1) (this rounds A1's value to 1 decimal place)
followed by your current formula.