As you can see we have have formatted C2 to display a percentage and it does. Click on the Math Trig functions category. SUM is a great basic formula to know especially because it allows you to add up numbers in different ways.
This option is very useful to find out all the formulas in a worksheet.
We entered the same formula in D2 but formatted the cell to display a number with 2 decimal points so Excel displays5 - which is the decimal equivalent of 50. This option is very useful to find out all the formulas in a worksheet. MATHEMATICAL Functions in Excel Go to FORMULAS tab. Actually there is a Fill command on Excel Ribbon to help you apply formula to an entire column or row quickly.