But, even though you don't need to work with exact figures everyday, you may still want to refer to them occasionally. For instance, the formula =ROUND((SUM(A1 A2)) adds the figures in cells A1 and A2, then rounds them off to the nearest whole number. If you choose, you can nest a calculation within one of the rounding functions. When you use a rounding function, you have two choices about how to set up your formulas. By learning the options for rounding, you can make your spreadsheets more immediately useful for you. You may want to round off for billing purposes, or because decimal places don't translate well into the physical world - for instance, if the parts you need come in packages of 100, then the fact you only need 66 is irrelevant to you you need to round up for ordering. However, you don't need to be a specialist to find some of these methods useful. If you're a programmer, you may also be familiar with some of these methods. For statistical and mathematical purposes, 's Calc spreadsheet includes a variety of ways to round off numbers.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |