Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

microsoft works spreadsheet

Oct 6, 2005 12:22AM PDT

I am new to spreadsheets, and have created one for figuring water usuage accounts. I used easy calc to set a two different formulas in two columns. It fugured them as I wanted, rounding them off. But, when I set up the formula for totaling the account across the row, and then a formula to total the column of taxes, it apparently is picking up the dropped amounts from the round off,and it does not show a true total of the figures that are showing in the spreadsheet. I have looked and looked, and cannot find a setting to correct this.
I am using microsoft works ver. 6 that was installed in win xp on my computer. Thanks.

Discussion is locked

- Collapse -
Re: spreadsheet
Oct 6, 2005 8:31AM PDT

If you used Excel, there would be two ways to do this:
- either tell Excel to use the displayed (rounded) values in calculations, not the real ones (that's a global setting)
- use the round-function to put the rounded values in some cells, add them with the sum-function and display the result where you now have your total of the real values

I don't know Works, but I think the second way is more likely to be possible there. Search for the round-function in the Help.

Kees

- Collapse -
Re: spreadsheet
Oct 7, 2005 2:23AM PDT

Thanks so much. I found what you spoke of, and at first could not make it work on the total, but discovered that all I had to do was put in the formula for the lines that I wanted totaled, and it would be right if I had inserted the round in the formula for the calculations of one column times another. I was trying to put round in the total formula, too.
I am so appreciative of the help.

- Collapse -
(NT) (NT) Good job, and glad I could help.
Oct 7, 2005 3:27AM PDT