If that is the case, then you are probably better off separating the two functions, placing =SUM(A1 A2) in cell A3, and =ROUND (A3) in A4, and clearly labelling each function. 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.

Openoffice calc convert text to number