Calculate X Percentage Of Cost

Apr 15, 2008

I am trying to create a simple formula to extract cost from a total that includes both cost and and a percentage for maintanance. Assume $100, 10% of which is maintenance the remainder is cost. If I just subtract 10% from $100 I get $90, however 10% of $90 is $9 which equals $99.

ADVERTISEMENT

Figuring List Price - Cost To Show Discount Percentage

Apr 25, 2006

List Price $46.98 (e2)
Net Cost $19.53 (e3)

How do I enter a calculation that will show me my discount percentage from my supplier? (e4)

I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item.

View 9 Replies View Related

Calculate Cost Basis Of Inventory

Dec 14, 2008

I need a macro to calculate the cost basis of the inventory. ( Field F3 and F4 in Sheet1)

Please refer to attached sheet....

View 7 Replies View Related

If Then Or Else: Calculate The Cost Of A Cushion That Is Governed By It’s Thickness

Sep 21, 2009

use the “INDEX & MATCH” formula and I thank him very much for that. Now, I have another problem which I think the “IF & ELSE” statement may come into play. I am trying to calculate the cost of a cushion that is governed by it’s thickness.

Example:
ABCDEFGHI
1CushionB/FrontS/SideBorderQuantitySeat
2Feather121251£8.25
3Feather121241£7.32
4

B2 represents 12 inches
C2 represents 12 inches
D2 represents 5 inches
144 represents square foot

The calculation is,
F2=B2*C2/144*D2*£1.65*E2..............

View 4 Replies View Related

Auto Calculate Total Monthly Cost

Jan 26, 2014

I am trying to keep a running total of cost, here is what I am doing

A B C D E F G H I

Date Books Pencils tax Month Books Pencils Tax Total
1/2/2014 11.50 2.50 .76 January 35.85 13.50 3.44 52.79
1/5/2014 14.50 3.85 .83 February 10.95 1.50 .68 13.13
1/6/2014 9.85 7.15 1.85
2/6/2014 10.95 1.50 .68

I only used Jan and Feb as an example. So as you see on the right side I will have all 12 months for the year and I just want all the totals for each month to auto calculate. I will have between 15 and 30 entries each month.

View 5 Replies View Related

Time Calculation - Calculate Total Cost Per Job Per Person?

Dec 22, 2013

I am attempting to create a time chart that keep track how long a particular person works on an individual project to finally calculate profit & loss. Attached is the spreadsheet.

I am using invoice #'s to differentiate the jobs but have no clue how to make it calculate how much time was spent per job, per person then calculate the total cost per job per person?

sheets.time chart.xlsx

2014 tab- grey column is installer and white is shop employees
profit loss tab- all calculations done here
payroll tab- all cost data here

View 1 Replies View Related

Calculate The Future Cost Of Education Fee Assuming A Given Inflation Rate

Mar 23, 2007

I am trying to put together a spreadhseet that will calculate the future cost of education fee assuming a given inflation rate. I would like the reuslt to be highlihted in a list or a table. The user would only need input current fee, inflation rate and years where fees are payable. The spreadsheet would do the rest. I have laid this our best I can attached.

View 5 Replies View Related

Excel Macro Or VBA To Calculate Desired Profit Margin Depending On Cost

Sep 12, 2013

I need to develope a macro for Excel to calculate desired profit margin depending on our cost of each item. Here's the scenario.

A1: landing cost
If 0

View 4 Replies View Related

Calculate Percentage Of A Percentage?

Apr 26, 2013

calculating the percentage of a percentage and writing the formula for excel.

There are 295 people in a room, of the 295, 75 or 25% are mothers. (I know how to calculate 25% - 75/295 = 25.42) of the 75 mothers 35 have 3 children, 32 have 2 children and 10 have 1 child.

35 is what percent of 25%
32 is what percent of 25%
10 is what percent of 25%

View 3 Replies View Related

Calculate Percentage Of Value

Jun 21, 2014

I have a simple issue i cannot figure out how to write a formula for.

In A2 i have the number of operations.

In A4 i have the percentage of CPU usage it requires to complete those operations.

I need an output somewhere that will tell me how may operations I can get per 0.1% of CPU usage.

View 5 Replies View Related

Calculate The Percentage

Jan 26, 2009

I have attached a file with both a sample section of data on the first sheet and the outcome I would like on the second sheet... I would do it all manually but there are over 200,000 rows in the actual file.

The macro needs to calculate the percentage of sale for each reference number within each part number and move down to the next part number and do the same until it reaches the bottom.

View 9 Replies View Related

Automatically Calculate The Percentage

Jun 14, 2007

code needed to be able to automatically calculate the percentage needed from one year to the next. I simply need it to automatically create a third column each time the copy old data button is pressed, and I need the column to have the percent increase ((current year - past year)/current year). Hopefully you can understand what I am aiming for. I have the current code below, and I will attach a compressed and stripped version of my workbook.

View 13 Replies View Related

Extract And Calculate Percentage (%)

May 18, 2009

In the attched sheet, I am wanting to draw data from the worksheet "On-Off" Array $AI$14:$AJ$91 into column AA, while at the same time choosing the closest match to the time. I have managed to get the closest matching time into column AC.

What I am having trouble with is now calculating the number of staff on that break time (column Z) against the number of staff rostered on at that stage "On-Off" (column AJ). I thought it would be a simple division and format as a percentage, however something in it using the extract from the "On-Off" sheet is stopping me, and I cannot figure it out.

View 2 Replies View Related

Formula Calculate The Percentage

Nov 16, 2005

I have a row of numbers from 1 to 26 in cells A1 to Z1 representing numbers
'chosen' at random by 500 unique people.

I have another row of numbers representing the 'frequency' that the
aforementioned number was chosen in cells A2 to Z2.

Example:

1 2 3 4 5 6 7 8 9 10 11 ...
10 4 16 9 23 20 61 13 18 43 17 ...

Is there a formula that I could use to calculate the percentage (0%-100%)
that each number was chosen?

View 14 Replies View Related

Calculate Average Percentage

Apr 5, 2012

I have a column of percentages, how do I get an average % rate at the end of my column?

View 7 Replies View Related

Formula To Calculate Percentage

Dec 20, 2013

I need a correct formula to calculate percentage...mine is not correct

Cell J18 will hold the formula.Range C18:I18 will have values.

C18 will have a value for today,D18 will get a value tomorrow,E18 will get a value 1 day after tomorrow etc..etc..

J18 formula - =sum(C18:I18)/7

If I only has a value in J18 then it will divide that single number by 7.......can a formula only divide by entries in cells....if I have 1 entry then it divides by 1,if I have 4 entries then it divides by 4 etc..etc until thee is 7 entries.

View 4 Replies View Related

Calculate Cumulative Percentage

Apr 18, 2009

Microsoft Excel - Book1___Running: 12.0 : OS = Windows XP (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)boutB5=
BCDEFGH5JanFebMarAprMayJunTotal6-3%-2%5%8%5%5%???Sheet1

I have this example above which i want to know what is the total % change from Jan to Jun. In the total column, the result i got is 19% using formula
=1*(1+B6)*(1+C6)*(1+D6)*(1+E6)*(1+F6)*(1+G6)-1.

Is there any other more simplified or better formula that can be used actually?

View 9 Replies View Related

Calculate Percentage Of Attendances

Nov 14, 2009

What I have is four columns with data. First column name second column number third column name fourth a number. Trying to get the total of the numbers for the names. So the first and third columns have names in them and they can be in each column or just once in either. I need to get a total column with all the unique names and then their corresponding number (added together if they are in both columns) to display the name and total. The names could be duplicated in each column as we (hopefully) have a lot of the same people coming week in week out.

What it is being used for is a two week and four week revolving attendance. I have a daily sheet one that I am using data filter unique values and then a countif to show me their attendance for the week. Putting it into a totals page sheet with week 1 week 2 etc.

So looking for a way to get all the unique names and their corrorsponding cell value added together to show the persons attendance for two weeks and then the month.

View 9 Replies View Related

Calculate & Display Percentage

Oct 27, 2006

how to display a percentage in a field in excel.

EG.

If I have a calculated price in cell A and I would like to enter a price manualy in cell B , how would I get excel to display in another cell what perecentage A is of B

price A would would be for example a purchase price , Price B would be a suggested retail price entered manualy and i would want cell C to show me what percentage increase it is of price A

View 4 Replies View Related

Formula: Calculate Percentage

Nov 15, 2006

I have in row D a list of numbers and in cell F a list of salaries. I need a forumla to tell me what percentage D1 is of F1 etc.

IE the formula will be something along the lines of D1 * 12 / F1 * 100

View 5 Replies View Related

Calculate Percentage Between Two Cells

Jun 26, 2007

in A1 I have 57 in B1 I have 75 so if I calculate percentage between those two I should get somewhere around 5% instead I'm getting 76%,

what am I doing wrong, in C1 I have =A1/B1 and then formated under percentage.

View 6 Replies View Related

Calculate Weighted Percentage

Oct 18, 2007

In my spreadsheet (testing.xls) I have a chart to mark the quality of a phone call based on a list of 8elements being judged. I have a likert scale for the quality result for each element, say for example 5 for highest, 3 for average, 1 for the poor, 0 for very poor and NA for an element which is not counted.

At the bottom of my table I have a cell where it would work out the % based on the outcome of the result from the different cells being ticked, what would i need to do to have excel work this out for me? Please bare in mind that if there is for example 1 element out of the 8 elements marked as NA the result would be divided 7 instead of 8.

View 9 Replies View Related

Custom Field To Calculate Percentage

Jan 22, 2014

I have a pivot table that analyzes test results. Assume three fields: Test, Result and Failure. If a test resulted in a failure then there is 1 in this field; otherwise there is a 0. There are several test results for each test. I want to calulate the percentage of failures for each test. I have selected Test for Row Labels. I cannot figure out how to calulate the percentage. Basically, the formula equates to =SUM(Failures)/COUNTA(Test). In other words, for each test add the failures and divide by the total number of results for that test.

View 2 Replies View Related

Macro To Calculate Range By A Percentage

Jun 26, 2009

I'm trying to do a forecast of my organization's budget for the next five years and need to create scenarios where certain figures will either be increased or decreased by a specified percentage that varies from 5% to 20%. I have recorded eight macros that can accomplish this task, but I feel like there must be a more effienct method.

In addition, I would like to increase or decrease the figures from either column H or column J. Column R is the results column. This is the macro I recorded that provides for a 10% decrease:

View 5 Replies View Related

Calculate Number Based On Percentage

Aug 10, 2005

example 1:
This years sales are $3700, a decrease of 11.6%. What would last years
sales be?

example 2:
This years sales are $4500, an increase of 151%. What would last years
sales be?

View 12 Replies View Related

Calculate Percentage Based On The Number

Jul 17, 2008

I am working on a spreadsheet which has lots of data in it. I have a Column i.e. Checked out and on each cell entered an X Mark indicating that a device has been checked out.

Since this Checked Out Column goes all the way down to > 1000 cells. Is there a way for us to make a formula and calculate percentage based on the number of X's that are entered and tell as that out of 1000 cells, the X's are 65% and so the blank cells would have to be checked to complete the list?

View 11 Replies View Related

How To Calculate Percentage In Pivot Table

Jul 6, 2012

I have a pivot table in which 50 rows data and each row contains in the end %age. End of report i get grand total but it sums the percentage column. I need to calculate percentage in the end of grand total. How can i get it.

View 3 Replies View Related

Formula To Calculate YTD Total Percentage

Jun 10, 2013

Formula to calculate the YTD % ?

If A1= YTD 100% and B1, C1 ,D1 etc.. do represent the month of Jan, Feb, Mar...etc

What do I have to use for A1 to auto-cal Jan - Dec?

View 2 Replies View Related

One Value With Multiple Values Within - Need To Calculate As Percentage

Jan 16, 2014

I have a list of group ID codes, which contain 1 or more product codes within them.

Some product codes contain an "alternative" value (the actual value is irrelevant) and others do not. See example below

Group ID
Product Code
Alternative

56381
240027
160380

[Code] .....

Ultimately what I need to achieve is a percentage of how many product codes, within each group ID, contain an alternative.

So for the example above, group ID 56381 would have 50% codes with alternatives.

By counting the occurrences of a group ID and whether 1 particular code has an alternative I have calculated individual percentages against the size of the group e.g. product code 240027 (given a value of 1) divided by the total number of codes in the group (4), returns 0.25. Obviously doing this across the whole group would give my result (0.5 or 50%)

However some groups contain over 100 codes and the spreadsheet is 40K rows!

View 5 Replies View Related

Calculate APR (Annual Percentage Rate)

Feb 13, 2010

I am trying to calculate APR (Annual Percentage Rate) for a mortgage loan that has a balloon feature. I have tried to the the RATE function but it only gives me the APR for a loan that is ammortized over 30 yrs and paid in 30 years. I need the APR for a loan that is ammortized for 30 years with a baloon in 5 years.

View 9 Replies View Related

Calculate Percentage Based On Criteria

Jul 29, 2006

I have events in column 1,in my sheet there are about 800 events.

In col 2. each contestant has a label,blue(b),green(g) or red(r)

In column 3 I want to print the % of blue + green of the total for each event,

e.g first event in attached sheet would show 77.7% down to row 10 in col 3 etc.

View 9 Replies View Related

Calculate Percentage Of Positive Numbers Only

Jun 28, 2007

I am trying to find a formula to calculate the percentage of the positive numbers in a column. For example, if I have a column that has positive(green) numbers and negative(red) numbers in the cells to show over daily goal or under daily goal, and I want to at know what percentage of all the numbers are the positive ones.

View 3 Replies View Related

Calculate To Percentage Reached, Then Start Over

Aug 9, 2007

I have a column that is a percentage(p%) which measures the fullness of the location(loc) that the item(ite) is in, which also has a corresponding location(loc) and item column(ite).

What I need to do is add as many items(ite) to one location(loc) as possible without exceeding 100%(p%), however if the value exceeds 100%(p%) then we need to start all over in a new location. The end result would be an unknown amount of unused locations.

If p% < 100 then add the next row's p% value, else start over with a new location. I am trying to add as many items to one location as possible, and once a location fills up, we will use the next one.

View 6 Replies View Related

Calculate Numbers Required For X Percentage

Aug 14, 2007

what I'm trying to do.

Background:
I play a game that requires 5 members to play, however you can have more then 5 members on the team. In order for a player to receive points for playing they must have played at least 30% of the total games played. The problem for me is when trying to figure out how many games someone needs to play to get to 30%, the total goes up as they play those games.

What I would like to accomplish:
I'm looking for help on a formula that would figure out how many games a player would need to play to get to 30%. I have a column that is total games played, %of games played by player, games played by player, and games needed to play to get to 30%. Basically the user would enter the # of games played by each player, and the total games played overall for the team for that week, the spreadsheet would then show the # of games each player that isn't above 30% would need to play.

I tried to make the question as clear as possible, if anyone needs clarification,

Originally Posted by shg
Welcome to Oz, Basca

spreadsheet with a representative sample of your data?

Games Played
Player 1 20
Player 2 7
Player 3 13
Player 4 20
Player 5 13
Player 6 13
Player 7 7
Player 8 7

Total Games Played20

View 9 Replies View Related

Calculate Percentage Of Text Occurences

Sep 11, 2007

I am having problems with a macro I wrote that basically fills things in two columns based on a set of values from other columns.

Lets say it looks like this (column B is based on column A):

A1 = Hi
A2 = Hello
A3 = Hi
A4 = Hello
A5 = Hi
A6 = Hello
A7 =
A8 = Hi
A9 = Hello
A10 = Bye

After the macro runs, column B should look like this:

B1 = 10%
B2 = 20%
B3 = 10%
B4 = 20%.............

View 9 Replies View Related

Calculate Percentage With Greatest Denominator

Jan 24, 2008

I have two columns of data, in another column I have the difference between these two columns, now I want to show the difference as a percentage. Assume cell A is 0.02 and cell B is 0.03 the difference is 0.01 and the percentage of the difference would be 33% or 0.01/0.03, my problem is when cell A is 0.04 and cell B is 0.01 the same formula wouldn’t work in both cases since in the first A<B and the second A>B is there a way that I can take the difference and divide it by the greater of A and B without having to do it manually?

View 6 Replies View Related

Calculate Percentage Of Total Salary

May 4, 2008

I have percentages set up for my monthly costs (student loans, food, spending money) and I want to be able to type in my weekly salary and have the percentages break it down into dollar amounts. Later, I'd like to put that into a pie chart, but I'm really only asking for help referring each category/percentage to the total $ value I enter each day/week/month.

View 4 Replies View Related

Formulas To Calculate Rent Increase Percentage

Aug 6, 2014

I am trying to do a spreadsheet that calculates the monthly rent from 9/1/14 through 1/1/15, then rent gets reduced from 2/15/14 through 1/1/16, then after that there will be an increase of 3% per year for each year until 8/2019.

View 1 Replies View Related

Calculate Percentage Of Specific Boundary Of Marks

Aug 24, 2014

If we have marks for students in some grade in all subjects, in each subject if we make the marks bounded in (50<, 50-59, 60-69,70-79,80-89 & 90-100).

How we can find the percentage for each boundary?

View 5 Replies View Related

Calculate Taxes And Pension As A Percentage Of Total W-2

Dec 16, 2009

I have attached a sample workbook of what I am struggling with. It is for payroll, and I need to calculate taxes and pension as a percentage of Total W-2. The problem is that the 'Total W-2' column then deducts these taxes and pension.

Currently, the worksheet has about 30 columns out to the right using 'guesses' to back into these numbers, but I hope there is an easier way.

View 14 Replies View Related

Multiple Drop Down Menu To Calculate A Percentage

Nov 6, 2008

I have a bunch of cells that use a drop down menu validation from a different set of cells so

Legend (this are in cells $A$7:$A$11)
NA - Not Applicable
0 - Not attempted
1 - Not Yet Competant
2 - Satisfactory
3 - Exceedes Expectations

Other cells have Data Validation using Allow List =$A$7:$A$11 to make the drop down menu option appear. What I would like to do is add a 'hidden number' on cells A8:A11 (A8=0, A9=1, A10=2, A11=3) A7, being NA isn't included in the formula I want to set up.

In cells later on I'd like to make a formula that takes those 'hidden numbers' into account and works out an average. So 'hidden number' / 'potential total' and make the cell display as a percentage, the 'potential total would have to take into consideration that a value has been set, but not use that value, and times the number of values set by three.

View 10 Replies View Related

ADVERTISEMENT