I want to use a combo-box on my sheet to deduct 30% from an amount in cell A1 if 'Yes' is selected in the combobox. For arguments sake the amount in cell A1 is 100.
I want the new total to appear in cell A2
If no is selected in the combo-box, then no calculation is performed and 100 remains in cell A2
For the below macro.
ABCDG
CodeTotalBaseNetA1 = 20%
A110083.3316.67A2 = 10%
A2350318.1831.82A3 = 7%
A3220205.6114.39A0 = 20%
A015015030
A1 is the code, take the total(B) and calculate the base(C) on the percentage given in the G, net = B-C. for A2 and A3 it is the same process.
For A0 the total (B) is equal to Base(C) and calculate the net on the given percentage in G.
I am trying to write a calc for a total an amount based on a list choice
Here is the Set up
Fields A1 thru A255 are number 1 to 255
Fields B1 thru B255 are number 255 to 1
Field C1 is a List box set using A1 to A255 and its list
Field D1 is set as the needed Calculation
When you choose a number in C1 the D1 calculation should total the amount of Fields B* to B1, * being the corrisponding B field to the A field from the list
Example C1=100 (Field A100) D1=Sum of Fields B100 to B1
The MS State Tax Credit maximum per person, per year is $500.00. I need to multiply the monthly credit allowance by 12, then multiply that by 25%. This answer must not exceed $500.00. I need this formula for both the male and female. I can't figure out how to make the formula both a SUM and an IF.
EX:
(79-D22)*(D20*12*25%max $500)+(83-F22)*(F20*12*25% max $500)
i have a user form with list box and text box, in the listbox i have A,B,C.....and so on, which corespond to column A on sheet 1, a b c.... all have a value next to them in column B say "1000". when a command button is clicked i need to search column A for list box value and deduct what ever number i add to the text box fom it's value in column B.
View 7 Replies View RelatedI need a formula to calculate the amount due based on cumulative sales once a breakpoint amount is reached.
Example:
Breakpoint:
cum sales are > 500 pay at 3%
cum sales are >1,000 pay at 2%
month/ sales/ cumul sales/ amount due
jan/ 100.00/ 100.00/ 0
feb/ 600.00/ 700.00/ 6.00
mar/ 600.00/ 1,300.00/ 18.00
and so on...until the end of year.
I tried using an if formula by could not get it to work.
The code below basically adds addresses to both the page and the oracle backend. However I am trying to work out how to limit the number of addresses they can add to 100. Therefore is it possible via code to calculate If Me.finish.Value minus Me.start.Value is greater than 100 then stop the code?
View 4 Replies View RelatedI want to select a range. The address of the range is governed by a range object called customers which is dynamically generated.
Customers will run from A1 to an address I can't predict. How can I specify the range address to be selected. I presume I enter some code that says go from row 1 column 1 to the last row, last column but I'm not sure how.
Im trying to set up an active running inventory sheet where: (A)the progressive daily sheet cells reference back to the corresponding master sheet cells fluctuating the master values, (B) the same progressive daily sheet cells reference back to a cummulative totals-cell based on whether I added or subtracted inventory. I want to make a copy of the blank "sheet 2" with all of the formulas and move it to the end of the workbook each day and enter new values which will reference back to the master sheet so that I can click on a date sheet and see an individual day's values or click on the master sheet to see the fluctuating inventory on-hand and the cummulative +/- totals of all days combined. I've got a couple hundred individual cells to reference. I've tried and tried but I can't make it work. Heres what I need to do:
I need to reference individual cells from "sheet 2,3,etc" back to a corresponding cell in a master sheet. But I need the values in each cell in "sheet 2,3,ETC" to increase or decrease the corresponding cell values in the master sheet. For example: If the value in the master sheet B5 is 200. Then in sheet 2, I enter +50 in B5, I need the master sheet cell B5 to increase by 50 to 250. I also need a way to decrease the cell value in the master sheet B5 if I enter a negative value -50 in sheet 2 B5. I also want to know if I can reference the same cell values entered in "sheet 2,3,etc cell B5" back to totals columns C5 for adding inventory or D5 for subtracting inventory in the master sheet where the master totals columns would reflect cummulative totals added or subtracted. For example: if the value in sheet 2 B5 is +50, then the value in Master sheet C5 would add 50 to a progressive total. But if the value in sheet 2 B5 is -50 then the value in master sheet D5 would add -50 to a progressive total.
I want to make a combo box in excel that, if i select it the sheet inside the combo box will appear.
Example:
Inside of combox are: Sheet1
Sheet2
Sheet3
If i click combo box and i choose sheet3 the sheet3 will appear.
How can i do this? theirs a macro code to use?
I created a invoice with excel that has dropdown selectors for the product then used Vlookup to insert the price , enter in the quantity and it fills the total. My question is when I Save & Close is there a way to deduct the quantity of the product on the invoice from the current inventory? They are 2 seperate worksheets in the same work book. This is far beyond my novice capabilities
View 7 Replies View RelatedI work different length shift some of which are over-night. I'm using the formula
=IF(((C1-B1)*24)<0,(C1-B1)*24+24,(C1-B1)*24)=IF(((C1-B1)*24)<0,(C1-B1)*24+24,(C1-B1)*24)
Where cell "B" is start time and cell "C" is finish time. This calculates hours worked whatever shift I'm on.
Is there anyway I can also deduct a hours rest break if I work more than 7 hours ?
how to deduct a percentage off of a range of units.
For example, if I have 100 units that cost $50, I'd like to deduct 20% off of the first 10 units, and then have the total dollar amount put into a separate cell.
So, 100 x $50 = $5000
With 20% off of the first 10 units: $4900.
__________________________
20% of $50 = $10
$10 x 10 units = $100
$5000 - $100 = $4900
i have a property and tenants have arrears in rental When i receive money from tenants i want excel to deduct that amount from arrears column first then balance from current rent.
View 4 Replies View RelatedWhat can I do to link my worksheets together? I need the months to link from january to december.
I'm trying to come up with a system to maintain attendance of employees. How do I come up with a rolling system to add and deduct the points as their attendance changes? The goal of each employee is to have the least amount of points as possible, because he/she will be penalized once they receive a certain amount of points.
Let's say that Jane was hired in October. She has accumulated 10 points by December from tardies, call-ins, etc. By the end of January, she has perfect attendance; she is awarded half a point to be taken off toward her 10, giving her 9.5. In February, there is a day she does not show up, so now her total goes up to 12.5 (3 pointed added because of NCNS-no show no call). In March and April, she has perfect attendance, so now her total is 11.5. (half a point allowed for each month with perfect attendance)
By rolling, I mean a formula that will calculate continuously over month after month and have the points roll over month to month.
The first combo box is on a userform so that a subject can be selected
View 3 Replies View RelatedI am trying to subtract an amount from a cell until it reaches 0, then move and subtract from the next amount, and so on.
AmountFixed BudgetedResult53.50Subtracted 5 tell it hit zero1.30Subtracted remaining amount until zero43.8Subtracted remaining amount until zero3.8 was left over without hitting zero is good. Is there formula for this?
In a financial environment we have a calculator which uses iteration to allow for a cost being added to loan amount where the cost is based on the total loan amount. Iteration is set to 100 iterations with max change .001
On one PC the first time the calculator is opened it gives a particular (incorrect) result. If the input cells are cleared and the data re-entered, it gives the correct result. This only happens on one particular PC. Is there some other setting , other than the iteration setting, that would cause this?
I have to create two combo boxes and when a user selects a value from one combo box, the values should get changed in the other combo box.
For example : if one combo box has values like "c/c++ programming" "java programming" and so on.. ... i would like to display the authors recommended (corresponding to combo box1) in the combo box 2.
a formula that I could deduct one time from another and get an answer that gives me the total times in hours and minutes.
So in the case of a person starts work at 7:56:24 and finishes at 15:24:20 - What formula would I need to calculate the amount of hours and minutes worked.
I need some code to do the following.
Look at worksheet 1. Find column "Amount". Insert column next to amount.
For all highlighted cells in column "amount" insert text "R" in adjacent (inserted) column.
I would like to create a combo box however the contents of the combo box depends on what i have selected in a previous combo box.
View 2 Replies View Relatedmake a calculation(addition) and use the answer to multiply against another addition calculation....
The sum of (Monday!A1:A4) multiplied by the sum of (Monday!B1:B4) plus (Tuesday!A1:A4) multiplied by the sum of (Tuesday!B1:B4) and so on.
I want a macro to take the current time and if it is less than 09:00am, I want it to set a variable to be the current time on the previous day.
Basically, an operational day runs from 09:00am to 08:59am the following day.
08:45am on Saturday 13 July (for example) should be recorded as 08:45am on Friday 12 July.
How can i sum up the amount of all "case" sold in the second month of 2009.. so the output should appear in C11 as i have already done manually.
View 9 Replies View RelatedI have used and adapted the following code for my sheet:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=824
But this combo-box only appears when I change from and back to the first sheet. I would like to either let the combobox appear
-when I open the file or
-when I click anywhere in the first sheet (can be a specific cell, or not)
Another solution would be to "fix" the combobox to a specific cell, ie not make it pop up anymore but just have it there.
I am having a few problems trying to amend the code so that it only uses the text box and combo box below. Unfortunately I am having a few problems. I am new and have amended this spreadsheet / code from another user on this site.
When I delete the combo box on the right, using developer mode, a run time error occurs.
I've got a worksheet which uses comboboxes at certain points for users to input data. At other points in the sheet they are entering directly into cells.
I've got the sheet protected, with the input cells unlocked so that it is possible to jump to them using the tab key.
However, I can't seem to make the tab key jump to any of the comboboxes. Ideally I'd like to set the full order for the tab key so that it jumps between input cells and comboboxes at the required stage.
I am trying to set-up a database where a list of people are trained on different items of equipment.
Is there anyway of doing this example please?
John is selected from a drop down box.
If he is trained on certain equipment, the box will turn green automatically. If he is not, the box will be red.
I am assuming, I will have a separate sheet housing all the names and what areas they are trained in.
Trying to add a formula in my spreadsheet that will add every amount in column AQ8:AQ200 if the date in AQ8:AQ200 is march.
The format for the date is 3-12-09.
Here is what I'm trying.
=SUMIF(AU8:AU200,MONTH=3,AQ8:AQ200)