add & subtract on an excel sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to add and subtract on the same sheet
I am trying to set up a sheet where I add inventory on one line and then
subtract on another as it goes out of warehouse
 
If A1 is your beginning inventory, A2 what has been added, A3 what has been
sold and A4 what is left over: This formula in A4 should do it: =(A1+A2)-A3.

Patrik
 
Riggs,

I think we need more details on the format of the data to give you a decent
answer.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to subtract a number from a Mergefield? 0
I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Excel Formula or equation 3
Add/Subtract columns from tab to tab in same file 3
Subtracting time...again 2
I want to add or subtract a range of cells 2
add & subtract time in 1 formula 2
3D worksheet question 1

Back
Top