kvmjournal.blogg.se

Enter the first number followed by the minus sign and then the second number.

Put the equal sign (=) in a cell where you need the outcome to appear.Here are simple steps to enter the formula in the sheet: Here is the basic formula you can use for the subtraction function:Īssume that you need to minus 20 from 100 and for this you will enter the formula as: With the help of the minus sign (-), you can easily manage to subtract two columns. There’s no direct way to use the subtraction function, however, as you know Excel always finds a solution. In this post, let’s see how to subtract two columns in Excel. Regular Excel users know that Excel allows you to subtract numbers, percentages, months, days, dates, minutes, hours, and seconds as well.Īpart from that you can even subtract text strings, characters, columns, and rows.

It lets you subtract one number from another by using the minus sign. Subtraction is one of the basic operations you can use in Excel. In the previous post, you learned how to subtract one cell from another in Excel.