# Excel formula creation

Hi! I would like to create an formula for in and out stock control system.
For example: Total Stock minus OUT quantity= Live stocks (10-5=5)
I am taking out stocks many times per day with different amount, so I need to have an total that is up to date. THANKS!!!

Posted by on

Hi, I need to have the TOTAL that is only changing when add/take away stocks. The input value is every time diferent.
I tried to play with macros a litle and it worked with stock OUT.
Find below the macro...

Private Sub Worksheet_Change(ByVal Target As Range)
Set r1 = Range("K2:K1000")
Set r2 = Range("L2:L1000")
If Intersect(r1, Target) Is Nothing Then Exit Sub
Application.EnableEvents = False
Target.Offset(0, 1).Value = Target.Offset(0, 1).Value - Target.Value
Application.EnableEvents = True
End Sub

Posted on Sep 06, 2008

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Expert

= (a3) minus (b3) won't do it for you?

Posted on Sep 05, 2008

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### What is formula to find percentage of females in my workplace?

To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

### How to do percentages in Excel - Office Blogs

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > Excel-Formulas
Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

### Excel formula: Get percentage of total ' Exceljet

https://exceljet.net/formula/get-percentage-of-total
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

### How to calculate the percentage using the excel

Hide All
Percentages are calculated by using the following equation:
amount/total = percentage
Where percentage is in decimal format.
What do you want to do?

Calculate the amount if you know the total and percentage For example, if you purchase a computer for \$800 and there is an 8.9% sales tax, how much do you have to pay for the sales tax? In this example, you want to find 8.9% of 800.
Example The example may be easier to understand if you copy it to a blank worksheet.

1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.
1 2 A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20) Note To convert a number in percentage format to a decimal, divide it by 100. For example, the sales tax in this example (8.9) divided by 100 is .089.
Calculate the percentage if you know the total and amount For example, if you score 42 points correctly out of 50, what is the percentage of correct answers?
Example The example may be easier to understand if you copy it to a blank worksheet.
1. Create a blank workbook or worksheet.
2. Select the example in the Help topic. Note Do not select the row or column headers.
Selecting an example from Help
3. Press CTRL+C.
4. In the worksheet, select cell A1, and press CTRL+V.
5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Formulas tab, in the Formula Auditing group, click the Show Formulas button.

Simple way Amount/Total*100

Apr 30, 2011 | Computers & Internet

### Steps to figure out formulas in excel

Hello this is Baris,
If you forget about the numbers and start naming your cells you can figure out your own formulas... Example :)

You buy apples, and you pay \$2 per piece

in this case you have 2 numbers to find out how much you will pay.

price per apple
quantity

you have 3 apples you pay 6 dollars very simple right. 2 times 3.

Same thing in excel but this time you will just say price times quantity and excel will do the calculation for you.

Type in A1 Price
Type in B1 Quantity
Type in C1 Cost

Now, Column C is your calculation area.
Type in A2 2 (price for apples)
Type in B2 3 (quantity of apples)
Type in C2 =A2*C2 (price times quantity)

Now on, you don't have to calculate anything. You can change you price and quantity, cost will change by itself. Because the value in that cell is now related to other values in A2 and B2. I hope this gives you a starting point.

Sep 30, 2009 | Microsoft Excel for PC

### How do i insert a formula in a column to add each number & give a total at the bottom?

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

### Writing a formula for a sumif problem

Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:
- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear
- Use this formula =SUMIF(E8:E26, 1, H8:H26)
For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

### HOW TO CALCULATE PERCENTAGE IN MICROSOFT EXCEL?

Hi nastyguy3000;

To calculate a percentage in excel you simply take
amount/total = percentage in your cell

Example A B Purchase price Sales tax (in decimal form) 800 0.089 Formula Description (Result) =A2*B2 Multiplies 800 by 0.089 to find the amount of sales tax to pay (\$71.20)

Have Fun

Mark

Don't forget to leave a rating.

Feb 19, 2009 | Microsoft Computers & Internet

### How to do profit and loss a/c in ms excel

Hi saleem_share,
I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:
Description
Amount
Formula
Sales Product A
1,000.00

Sales Product B
1,000.00

Total Sales
2,000.00
SUM(C1:C2)
Cost of Sales Product A
500.00

Cost of Sales Product B
200.00

Total Cost of Sales
700.00
SUM(C5:C6)
Gross Profit
1,300.00
SUM(C4-C7)

Auto
25.00

Utilities
50.00

Payroll
300.00

Office Supplies
20.00

Total Expenses
395.00

Net Profit
905.00
SUM(C8-C14)

I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

### Excel

Step1. Start Microsoft Excel and open the file you want to change. Step2. Double-click on the cell where you want the total to appear. Step3. Press the = key on the keyboard. This tells Excel that you are entering a formula into the cell. Step4. Enter the formula, then press Enter. Follow the steps below for an example. Step5. Enter an opening parenthesis character: (. Step6. Enter a cell name. For example: =(E2. Step7. Press the + key. Step8. Enter another cell name and a closing parenthesis character: ). For example: =(E2+E3). Step9. Enter a minus sign and a third cell name. For example: =(E2+E3)-E4. Step10. Press the Enter key to accept the formula. The cell will display the sum of the first two cells minus the third cell. \$('.Article .Steps .Image').each(function(i,e){ e = \$(e); e.find('img').error(function(){ \$(this).unbind(); e.remove(); }); });
Tips & Warnings
• Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell.
• Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. (See "How to Use Provided Excel Formulas.")
I hope it helps!!!

Dec 03, 2008 | Microsoft Office Professional 2007 Full...

### STOCK REGISTER

Just keep a common database on internet for all stores & create website (ASP or PHP) or web based application(like Vb.Net or VB) much preferred.
.
so any sales occurs, it would be reflected across all stores,
so you can calculate total sales & remaining stock any any time and sort it or aggregiate it daily, weekly & montly..

Nov 27, 2008 | Computers & Internet

### Need a formula for excel

select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

#### Related Topics:

153 people viewed this question

Level 3 Expert

Level 2 Expert