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. *Other Files: stc, std, sti, stw, sxd, sxi, sxw, sxc, sxm, kth, cwk, pmd, p65.For statistical and mathematical purposes, 's Calc spreadsheet includes a variety of ways to round off numbers. *Graphic Files: bmp, jpeg, jpg, pcx, psd, sgv, wmf, pgm, svm, xbm, emf, emz, pbm, plt, tga, xpm, eps, pcd, png, hpgl, vsd, vsdx. *Presentations: ppt, ppa, ppsx, pps, pot, pptx, pptm, potx, potm, vor, uop, uof, odp, fodp, otp. *Spreadsheets: xls, xlw, xla, xlt, xlsx, xlsm, xltx, xltm, xlsb, wk1, wk3, wk4, wq1, wq2, wks, 123, wb2, ods, fods, ots. *Text Documents: doc, dot, docx, docm, dotx, dotm, wpd, wps, rtf, odt, fodt, ott, pub. You can choose a OpenOffice, Office, DOC, XLS, PPT, Text Document, Spreadsheet, Presentation, and Image file to view from Google Drive or from your computer. Support the printing feature, and you can be downloaded as PDF format. This viewer lets you view document, image files online without leaving your browser using OpenOffice™ software on the server. This app makes OpenOffice, Office, DOC, XLS, PPT, and Image files viewable in a web browser using OpenOffice™. This app makes OpenOffice, Office, DOC, XLS, PPT, and Image files viewable in a web browser using OpenOffice.
0 kommentar(er)
