Microsoft Excel is a popular spreadsheet software used for various purposes, including calculating and analyzing data. One of the basic operations that Excel can do is subtraction. In this article, we will discuss the formula for subtracting numbers in Excel or rumus pengurangan dalam excel.
Basic Subtraction Formula
The basic formula for subtracting two numbers in Excel is simple. You just need to enter the equal sign (=) followed by the cell reference of the first number, then the minus sign (-), and finally the cell reference of the second number. For example, if you want to subtract the value in cell A2 from the value in cell A1, you can use the formula =A1-A2.
Subtracting Multiple Numbers
If you want to subtract multiple numbers in Excel, you can use the same basic formula. Simply enter the equal sign followed by the first cell reference, then minus the second cell reference, and so on. For example, if you want to subtract the values in cells A2, A3, and A4 from the value in cell A1, you can use the formula =A1-A2-A3-A4.
Subtracting Numbers with Negative Values
If you want to subtract numbers with negative values in Excel, you need to be careful with the syntax. You need to enclose the negative value in parentheses to avoid errors. For example, if you want to subtract the value in cell A2 from the value in cell A1, but cell A2 has a negative value, you can use the formula =A1-(A2).
Subtracting Numbers in Different Sheets
If you want to subtract numbers in different sheets in Excel, you need to use the sheet name before the cell reference. For example, if you want to subtract the value in cell A2 from sheet2 from the value in cell A1 from sheet1, you can use the formula =Sheet1!A1-Sheet2!A2.
Subtracting Numbers with Absolute References
If you want to subtract numbers with absolute references in Excel, you can use the dollar sign ($) before the column and/or row reference to lock the reference. This will prevent the reference from changing when you copy the formula to other cells. For example, if you want to subtract the value in cell A2 from the value in cell B1, but you want to lock the row reference for cell A2, you can use the formula =B1-A$2.
Subtracting Numbers with Relative References
If you want to subtract numbers with relative references in Excel, you can simply enter the cell references without using the dollar sign. This will allow the reference to change when you copy the formula to other cells. For example, if you want to subtract the value in cell A2 from the value in cell B1, you can use the formula =B1-A2.
Subtracting Numbers with Functions
Excel also has built-in functions that can be used for subtracting numbers. The two most common functions are SUM and SUMIF. The SUM function can be used to add up a range of cells, while the SUMIF function can be used to add up cells that meet certain criteria. For example, if you want to subtract the total sales from the total expenses, you can use the formula =SUM(B1:B10)-SUM(C1:C10).
Conclusion
Subtracting numbers in Excel is a basic operation that can be done using simple formulas or built-in functions. By understanding the syntax and using the right references, you can easily perform subtraction tasks in Excel.
