performing calculations on displayed/rounded values for currency



First, thanks to all the developers for gnumeric.

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

The only thing I've found is to use the round function for each of the
3 individual cells, but that gets tedious.

I don't care if it's not the default but it would be nice if I could
tell it to perform the sum on the displayed values when the format is
currency.  Is there a way to do this?

Thanks,
Dave




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