How to Subtract Two Columns in Excel
Subtract two columns in Excel with =B2-C2 and the fill handle, one spilling formula, a locked reference, a table or Paste Special, plus fixes for common errors.
How to subtract in Microsoft Excel: cells, columns, percentages, dates, times and more.
Subtract two columns in Excel with =B2-C2 and the fill handle, one spilling formula, a locked reference, a table or Paste Special, plus fixes for common errors.
Subtract time in Excel with =end-start, format the result as h:mm or [h]:mm, convert it to hours or minutes, and handle shifts that cross midnight.
Subtract multiple cells in Excel with =B2-SUM(B3:B7), a minus chain, negative numbers, absolute references or Paste Special, plus fixes for #VALUE! errors.
Subtract in Excel with the minus sign: cell from cell, whole columns, a fixed number, Paste Special, and fixes for #VALUE!, negatives and wrong results.
Subtract dates in Excel with a simple minus formula, DAYS, DATEDIF or NETWORKDAYS, go back days, months or years, and fix results that show as dates or #####.
Subtract a percentage in Excel with =A2*(1-B2), reduce a whole column with Paste Special, subtract one percentage from another, and fix wrong results.