To insert a value or mathematical operator into the formula, type the value or the symbol for the mathematical operation in theFormulabox. List of mathematical operations Operation Symbol Add + Subtract - Multiply * Divide / Note:If your formula uses the division (/) operator, make sure that...
Type=A2*$B$2in a new column in your spreadsheet (the above example uses column D). Be sure to include a $ symbol before B and before 2 in the formula, and press ENTER. Note:Using $ symbols tells Excel that the reference to B2 is "absolute," which means that when you copy...