Subtraction Formula in Excel Shortcut | Subtract Multiple Columns | Add & Subtract in One Formula

preview_player
Показать описание

In the Microsoft Excel video tutorial I explain how to create a subtraction formula in Excel. Please see the table of contents below for the different scenarios where you will need to perform a subtraction.

Table of Contents:

00:00 - Introduction
00:11 - Subtract two values
01:50 - Subtract values in two columns
02:56 - Subtract values in two rows
03:23 - Subtract one value from multiple values
06:07 - Subtract shortcut using Paste Special
06:47 - Subtract two columns' totals
07:38 - Subtract multiple values from one value
08:10 - Subtract multiple negative values from a positive value
08:35 - Subtract two tables
------------------------
Рекомендации по теме
Комментарии
Автор

Wow! This is the only video where I found all sorts of subtraction methods possible! Thank you so much for this.

Мр.Чыде
Автор

Thank you! This was clearly and simply explained.

glowingresults
Автор

a million. You have made our lives so much easier. Love your vids

wrxfreak
Автор

Excellent tutorial Chester, as always. The way 365 works is very interesting. Thanks for sharing.

IvanCortinas_ES
Автор

I had to double-check the date to make sure you weren't April Fool's pranking us. Nope, just a refresher of some basic stuff, which is sometimes handy to re-explore.

GeekinTX
Автор

This is a nice tutorial, but what if I want to subtract based on a selection on a drop-down list?

evanhizon