Home > Excel Help Portal > Excel for Mathematicians

<<  (Page 1)  Previous              Next  (Page 1)  >>

Excel for Mathematicians

The ExcelUser portal offers links to help pages created by top
Excel web sites. This section discusses math topics in Microsoft
Excel formulas.

1. Fractions rounded to 1/4, 1/8, 1/16, 1/32, 1/64, 1/128 The formatted display of fractional measurements in Excel leaves a lot to be desired. ; This example and the formulas shown below were generously provided by Bernie Deitrick as a follow-up to a posting 2000-08-04 in the microsoft.public.excel.misc newsgroup. Bernie's formulas will be simplified... Keywords: Analysis ToolPak, Download, Format, Formulas, HTML, Links, Comments, MROUND, TEXT

 
2. How to Find Secant, Cosecant, or Cotangent of an Angle Microsoft Excel has built-in functions for a large number of trigonometric functions, but does not include all such functions. However, those not included may be derived from existing functions by using a formula in Microsoft Excel. Some... KB#188075. Keywords: Formulas, PI

 
3. How to find the Secant, Cosecant, or Cotangent of an Angle in Excel 2000 Microsoft Excel 2000 has built-in functions for a large number of trigonometric functions but does not include all such functions. However, you can derive functions from existing functions by using an Excel formula. Some functions that you can... KB#213887. Keywords: Formulas, PI

 
4. Rounding to n significant digits Excel includes three functions (ROUND, ROUNDUP, and ROUNDDOWN) that round values to a specified number of digits. In some cases, however, you may need to round a value to a specified number of significant digits. For example, you might want to express the value 1,432,187 in terms of two significant... Keywords: Charts, Format, Formulas, Printing, ROUND

 

<< (Page 1)  Previous              Next  (Page 1) >>