performing calculations on displayed/rounded values for currency
- From: Dave Reed <dreed capital edu>
- To: gnumeric-list gnome org
- Subject: performing calculations on displayed/rounded values for currency
- Date: Wed, 10 Jan 2001 19:08:54 -0500 (EST)
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]