In excel to a display a calculated value with 2 decimal


In Excel, to a display a calculated value with 2 decimal places, one can use the format feature. However, there are times, when using the Sum function on a "formatted" range of cells, the sum total might not agree to the penny. For example: 0.02+0.03=0.06 Your task is to explain why this might happen and how it can be easily avoided.

Solution Preview :

Prepared by a verified Expert
Basic Computer Science: In excel to a display a calculated value with 2 decimal
Reference No:- TGS02479203

Now Priced at $10 (50% Discount)

Recommended (91%)

Rated (4.3/5)