Enter an equal sign followed by an open parenthesis to begin creating the formula. In Excel for Mac you dont need the parenthesis. For simple formulas simply type the equal sign followed by the numeric values that you want to calculate and the math operators that you want to use the plus sign to add the minus sign - to subtract the asterisk to multiply and the forward slash to divide.
Click the Week 1 Total cell which should be B10.
Calculates all open workbooks a specific worksheet in a workbook or a specified range of cells on a worksheet as shown in the following table. In the Calculation options section click the Manual radio button to turn on the ability to manually calculate each worksheet. The correct way to calculate this is by taking 305 which is 6 and multiplying it by 3 to get 18. Founder of Online Tech Tips and managing editor.