RE: performing calculations on displayed/rounded values for currency

-----Original Message-----
Consider the following spreadsheet cells, formatted as currency:

=0.02*916.67   (displays $18.33)
=0.02*916.67   (displays $18.33)
=0.02*916.67   (displays $18.33)
=sum(above 3 cells) (displays $55.00)

Is there a way to get the sum to be $54.99 (i.e., perform the sum on
the displayed rounded values which I believe is the default for

It is not the default on my copy of Excel.


[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]