Read more… How to Find Difference between Two Numbers in Excel? ![]() There is a alternate approach also & it is here. We have to do use the same operation as how we did with Adding Numbers in Excel. In Excel there is no function to do the subtraction directly. So, we can subtract numbers by adding a negative sign and performing a SUM operation like ‘=SUM(5,-3)’.Īll the above three methods will give the same results if we provide same input. Using SUM to Subtract: Subtraction is the same as adding negative number to another number. Using Cell Reference: Similar to direct calculation, cell references can also be used in the formula as ‘=B1-C1’, then Excel will subtract the number in Columns B1 & C1. If we type anything in a worksheet starting with ‘=’ sign, Excel treats it as a formula, executes the formula and display the result only. ![]() We have just entered a Formula in Cell that starts with ‘=’ sign.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |