Regarding the subtraction function of excel, there is a built-in function: IMSUB function. This function is the subtraction function of excel.

Its syntax is: IMSUB(inumber 1, inumber2).

Where the parameter: Inumber 1: required. The (complex) number subtracted. Inumber2: required. Subtract (a complex number).

As shown in the following figure: the number 1 minus the number 2, the formula of C2 cell is =IMSUB(A2, B2). Ok, select C2 cell again, point the mouse to the lower right corner of the cell, when a small black cross appears, hold down the left mouse button and drag it down to fill, and then copy the formula.

2.excel subtraction function related examples

As shown in the following figure: cell A 1 subtracts the following values in turn, and the formula of cell G1-c1-d1-e1-f1 If subtraction is needed.

Extended data

Microsoft Excel is a spreadsheet software written by Microsoft for computers using Windows and Apple Macintosh operating systems. Intuitive interface, excellent calculation function and chart tools, coupled with successful marketing, make Excel the most popular personal computer data processing software.

1993, after the release of version 5.0 of Microsoft Office component, Excel began to become the overlord of spreadsheet software on the applicable operating platform.

References:

Web page link