Can someone please give me an example of a subtraction formula using Excel. Im a bit thick thanks?

Question

Im just trying to get a left in stock figure at the end of each month with the ability to add more to the stock aswell. Examples would be appreciated.

Answer 1

Not sure what you want to do, but try this.

In the cell you want to see the "answer" type:

=sum(a-b)


where A is cell which contains the stock you stared with, and B is the cell that contains the total number of items sold.

So for example if you have a spreadsheet with total starting stock typed into cell A1, and total sold in December typed into cell B1 your formula would be:

=sum(A1-B1)

very difficult to explain in words that one!

Answer 2

Just use your closing stock for last month and take away stock used with in the month and add in you new stock brought in the month this will leave you with your stock left at any point in time.

Opening Stock Cell AI
Stock brought in month Total Cell A2
Stock used in Month Total Cell A3
=sum(A1+A2-A3) This total will give you your stock left
By changing any of the total in A2 or A3 this will follow down to you total left in stock.
Good Luck

Answer 3

Without specific limits on number of characters, this becomes very difficult within a worksheet. The best way is to write a function using VBA. Name a range called 'AlphaKey' that is 2 columns by 26 rows with the following info; '2 A '22 B '222 C '3 D etc... Then add the following function; Function TextMsg(n As String) As String Dim l As Integer, ch As Integer, s As Integer Dim a As String, b As String, kstr As String Dim tempMsg As String, KeyLet As String l = Len(n) s = 1 tempMsg = "" Do t = 1 For ch = s To l - 1 a = Mid(n, ch, 1) b = Mid(n, ch + 1, 1) If a = b Then t = t + 1 Else Exit For End If Next ch kstr = Mid(n, s, t) KeyLet = Application. WorksheetFunction. VLookup(kstr, Range("AlphaKey"), 2) tempMsg = tempMsg + KeyLet s = s + t Loop Until s >= l TextMsg = tempMsg End Function Good luck, feel free to contact me with any questions.

Answer 4

If you mean with cells:

type this into cell C1:

= A1 + B1 or = $A1 + $B$1

The $ before the cell label indicates that the cell value is fixed.

If you want similar equations in consecutive rows, copy the contents of cell C1 and paste into cells C2 to Cn.

To sum over cells do this:

= SUM(A1:H1). A1 = start cell, H1 = end cell.
If that's not what you meant, be more specific in the details of your question.

Answer 5

You don't have to use the sum function. Sum is for adding the contents of a large column of cells, when it's easier to type sum and select them all than to type all their names. To add and subtract a few values, all you have to do is this:

Assume cell A1 holds your starting inventory for January, A2 holds the amount brought in, A3 holds the amount sold/destroyed, and you want A4 to hold the amount left. Then you want column B to do the same thing for February, and so on.

In cell A4, type "= A1 + A2 - A3". That will put the amount left in stock there.

In cell B1, type "=A4". That will set your starting stock for February equal to the left-in-stock of January.

Now, click on cell A4, and in the lower right-hand corner there should be a small square. When you hover your mouse over it it turns into a crosshair. Click on this corner and drag it over to cell B4. This cell will now automatically calculate your left-in-stock for February, referencing cells in column B rather than column A.

Click on cell B1 and drag it over to cell C1. Your starting inventory for March will now be automatically calculated.

Repaet for as many months as needed. Now, all you have to do is fill in the amounts bought and sold, and your inventory will be calculated.

Answer 6

Subtraction:
=C1-C2 - where C is the column and 1,2 are the rows OR
=C1-D1 - where C,D are the columns and 1 is the row

Add
=C1+D1

Add using a column
=Sum(C1:G1)
this case means just put entire sum using all values between C and G columns and row 1.

Division
=C1/D1

Multiplication
=C1*D1

Be sure that you are using values, it what are you using is Text it will show #value or another error message.
Possible solutions(To_number formula or just <>)

Answer 7

Let us say u want the number located in cell A1 to be substracted in cell C2:

If this is the mathematical formula: C2 - A1

the formula in Excel would be: =C2-A1

type that formula in any cell u want that to be placed.

Answer 8

go to cell A1 type in any number
go to cell A2 type in any number

go to cell A3 type in =A1-A2

A3 will automatically type in the value of the first number minus the second number.

If you now change the number in A1 or A2, the answer will change.


thats the simplest subtraction formula you can have

Answer 9

it is actually a sum
put a minus sign in front of the cell number (example -B1)
here is a simple formula I did =SUM(A1-B1)

Answer 10

Put the "IN" figures in column A.
Put the "OUT" figures in columns B, C, D...till F.

Find the sum of all the "OUT" figures and place them in say column G: =sum(A1:F1)

In column H, you can find the difference: =A1-G1
[i.e the "IN" figures - the total of the "OUT" figures]