How to Use the MINUS Function in Google Sheets
Learn how to use MINUS in Google Sheets to subtract two cells, fill a column with ARRAYFORMULA, work with dates and times, and fix #VALUE! and sign errors.
Learn how to use MINUS in Google Sheets to subtract two cells, fill a column with ARRAYFORMULA, work with dates and times, and fix #VALUE! and sign errors.
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 Google Sheets with =B2-A2 and Duration format, fix overnight shifts with MOD, take hours off a time, and convert results to decimal hours.
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 on the Windows Calculator with buttons or the keyboard, plus mixed problems, percentages, M- memory, negative numbers and dates in Windows 11 and 10.
Subtract on the Mac Calculator with the minus key or on-screen keys, plus Spotlight, Math Notes, RPN, negative numbers, clearing mistakes and the history panel.
Subtract on the iPhone Calculator in seconds: chain numbers, take a percentage off, use Scientific mode or Math Notes, fix negative results and check history.
Subtract on an Android calculator in Google Calculator or Samsung Calculator: basic steps, negative numbers, percentages, chained math and fixing wrong answers.
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 SQL with the minus operator, subtract dates in SQL Server, PostgreSQL, MySQL and SQLite, compare rows with LAG and remove rows with EXCEPT or MINUS.