Calculations using Excel for Mathematics General and Standard.
An absolute reference in a formula does not change when the formula is copied or filled.
An absolute reference uses
=$B$1 the column and row do not change.
=$B1 the column does not change
=B$1 the row does not change
Addition, subtraction, multiplication and division.
Calculate the commission on sales.
A2 is the rate of commission (entered as a percentage)
B2 is the amount of sales