RE: performing calculations on displayed/rounded values for currency

["Phillip Shelton" <shelton usq edu au>]

> -----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
> Excel)?

It is not the default on my copy of Excel.

Phill