| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 46960 | 2004-07-11 02:23:00 | Rounding currency | Earnie (3226) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 251472 | 2004-07-11 11:01:00 | MS Works is nothing like Excel and if I had my way Works would be banned from any PC I support. Luckily I only have one. The reason I hate it so much is because of it holding your hand so much it actually interferes with what you want to do. | mikebartnz (21) | ||
| 251473 | 2004-07-11 12:04:00 | You need to set the cell as currency and two decimal points. Rounding rules change as well. This depends on what rules you implement. I have noticed that some firms in NZ use the Swiss system of rounding. If you are using Work6 I have a formula which will work for you. Possibly you can file attach your spreadsheet to me at:- tony.frew (at) southwaikato (dot) net [nz] I will have a look and Email back a solution for you if you want. |
Elephant (599) | ||
| 1 2 | |||||