![]() Likewise, the subtraction in excel can also be performed in two different cells. Once you know how the subtraction in excel works you can simply enter the numbers you want to subtract in the cell manually or the formula bar and press the Enter key to obtain the result. Press Enter and you will have the result displayed on the third cell.Ĥ. The subtraction formula can either be entered in the cell(as done in the third cell of Step 2) or in the formula bar as shown below. ![]() On entering the formula press the Enter key which will give you the result.ģ. The formula that you enter in the third cell should look like =A1 – A2. Suppose you are using cell A for your computation on the s preadsheet then let the first cell of column A have one value and the second the other. For example, let =SUB1 – SUB2 be your standard formula for subtraction.Ģ. Always remember to use an equals sign(=) before you begin with the subtraction formula and a minus(-) sign during the computations. Below are the steps that you need to follow to perform the basic subtraction in Excel.ġ. Subtraction in excel might sound a bit perplexing but when you are performing the actual subtraction on the excel sheet you will see how easy could it be.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |