dotrain4u Posts: 2, Reputation: 1 New Member #1 Mar 18, 2003, 05:51 PM
Excel Formula needed
I am keeping an inventory in Excel. Let's say I start with 100 units of widgets, I take 20 widgets from the shelf, but return 10 wdgets later because I didn't use them. I need a formula that shows the 100, then I want to show that I took 20, and then have Excel show that I returned 10. Can anyone help with this?
 dtecmeister Posts: 6, Reputation: 1 New Member #2 Mar 22, 2003, 07:17 AM
Excel Formula needed
1. New excel sheet
2. Sheet 1: 1st row: Balance | =SUM(Transactions!A:A)
3. Sheet 2:
100
-20
10
Call sheet 1 Balance and sheet 2 Transactions.

 Question Tools Search this Question Search this Question: Advanced Search

## Check out some similar questions!

Speed formula help [ 6 Answers ]

OK I am taking my first physics class and I am not doing too great in it, but the good thing is this is only the first week of class. My question is about the speed formula. I know that the formula is S=D/T, but I still get the problems wrong even thow I plug in the numbers right. Here is an...

p = x*(1 - (1+r)^-n)/r In words: take the negative nth power of (1+r). Subtract from 1, divide by r. This gives the ratio of p to x. I need to be able to solve for n. Can someone help me with creating a formula out of this to solve for n? :confused:

Formula for how much wood needed to make shelves [ 6 Answers ]

I need three 17x22 inches I need two 15x41 1/2 one 20x64 three 13x18 how much wood would I need to make these shelves? is there a formula that I could use for the future? thanks

Difference in the Formula calulation [ 3 Answers ]

I am a software engineer. We are creating an efficiency report of employees. we have two reports detail and summary of efficiency of employees. while calculating detail report we are picking up each jobcard done by an employee . Following is the example formula applied is as follows ...