How To Excel Subtraction Formula Complete Guide

Best Math Formula website. Search anything about Math Formula in this website.

how to excel subtraction formula. A2C4- E2G4 Press Ctrl Shift Enter to make it an array formula. For example 50 20 and 50 -20 are actually the same thing.

Excel Formula Symbols Cheat Sheet 13 Cool Tips Exceldemy Excel Formula Microsoft Excel Formulas Excel Shortcuts
Excel Formula Symbols Cheat Sheet 13 Cool Tips Exceldemy Excel Formula Microsoft Excel Formulas Excel Shortcuts from www.pinterest.com

Hit the Enter key and it will show the result in Cell D4. Here are the steps to make the formula. With the sign you need to put two or more numbers with -operator in between these numbers.

Use the SUM function to add negative numbers in a range.

This will give you result as 4. Use subtraction operator - after that. Content in this video is provided on an as is. For your budget for example you might type your months income into this cell.