Increase/Mark-up Cost By X Percent

Apr 15, 2008

Formula for figuring retail price from cost. ie Cheeseburger 1.00 cost and I want a 60% markup. (2.55 Retail)

ADVERTISEMENT

Cost Based Mark Up

Sep 26, 2007

set up a cost based markup spreadsheet?

I need to be able to mark up values from 0.01-9.99 by 20% of their value, and 10.00 and above by 10% of their value.

I only know how to mark up values by a single percentage.

View 9 Replies View Related

Increase Percent In Cell If Other Cells Contain Data?

Oct 24, 2013

I'm trying to track how complete a project is by checking if cells contain data, and if they do the percent in cell 'Y4' would increase.

I have 6 cells which represent milestones and if they contain data then they would add a certain percent to cell 'Y4'.

Cells B13 & R13 would have a weight of 15% each

Cells J13, J21 & J30 Would have a weight of 20%

Cell L34 would have a weight of 10%

Is there any way that if these cells contained any data that I could add that percent to the total in 'Y4'?

View 2 Replies View Related

Conditional Format To Mark Increase From Previous Column

Sep 5, 2013

I have a goal set for the year. With conditional formatting, each month will be set to either red or yellow based on where it stands in relation to the goal. I would also like to show an increase or decrease in productivity for each month. I tried to use conditional formatting with the formula:

=IF(C2=D2, "", IF(C2<D2,"↗","↘")).

The formula works on its own without the conditional formatting so I am not sure what I am doing wrong. I've attached a sample with all the conditional formatting and formulas in place.

View 5 Replies View Related

Taking Percent And Adding Subtracting Percent Formula

Sep 12, 2012

I have a percent 3.14%, that I want to show 15, 20 and 25% above and below that percent. I am showing below the results and then formula. The top calculation results in the same on both the left and right. However the -15,-20, -25% results are different. Which is correct.

3.14%

20% +/-
3.14%

0.63%
or
6.28%

1.57%

2.51%

[code].....

basic math, but I don't understand why the results are different.

View 3 Replies View Related

IF Function Formula Logic: For Every Increase Of Of Mhz, Give 25.00 Per 100 Increase

Nov 2, 2006

I have a test due in the morning, and I really need this question answered ASAP, if anyone could. I need to create an IF formula for this situation: the standard Mhz is 500. Give 55.00 for that standard. But for every increase of of Mhz, give 25.00 per 100 increase.

View 2 Replies View Related

Iteration Inconsistency: Allow For A Cost Being Added To Loan Amount Where The Cost Is Based On The Total Loan Amount

Mar 15, 2007

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?

View 5 Replies View Related

Top 90 Percent

Jan 23, 2007

how to mimic SELECT TOP 90 PERCENT from Access in Excel?

I can't use the percentile function because it interpolates the value if you don't have the right multiple of values in your array.

View 9 Replies View Related

#DIV/0! With A Percent

Aug 9, 2007

I have a spreadsheet that determines what percent increase over a previous quarter. The values can be negative or positive; however, I have one entry that I'm trying to divide zero by a number which results in the #DIV/0! error message. I rather have it say -1000% since that is the value I'm looking for. I now how to deal with a simple division by using an IF statement such as IF(B1,A1/B1,0), but this one is throwing me a curve.

The attached spread sheet is a quarterly percent increase over the last one. In the example, N00377 represents a machine in cell D14 and D17, where cell D17 is the last quarter, and I'm comparing it to cell D14 which should show an increase or decrease in cell F.

View 9 Replies View Related

Percent Rounding To Sum 100%

Sep 27, 2007

I have a set of data that is meant to distribute a certain number of items to different groups.

I have 10 groups, some will get more than others depending on previous usage. The problem is that I need the percentages to be in whole numbers and the total percentage needs to be 100%. I tried rounding but it doesn't work. Here is an example from one item's line.

Group#,1,2,3,4,5,6,7,8,9,10
Dist %,.1,0,.04,0,0,0,0,0,.87,0

These are rounded and it comes out to be 101%.

View 9 Replies View Related

Percent Over Last Year

Feb 16, 2010

I want to find the percent of increase over last year. If last year was 100 and this year is 500 then the percent would be 500%. However things get tricky if last year was -100 and this year is 500 or if last year was 100 and this year is -500 then it get's screwy and I'm not sure what formula to use to handle any situation.

View 9 Replies View Related

Figuring Percent %

Jun 18, 2006

This is what I have

Rate Hours =basePay plus 6% plus 7.1% total
$50.00 10 $500.00 $530.00 $567.63 $567.63

What i want to have is one cell that I can Total everything.
I want my spread sheet to display just rate, hours total
I am having troule making the formula to display everything in the total cell

View 4 Replies View Related

Percent Formula

Apr 30, 2007

I need a formula to show percent value in a certain way in cell D1
formula is
C1 = B1-A1

but I am stuck to get the percent syntax in formula bar right.
D1 = PERCENT OF B1-A1

Example1
A1 B1 C1 D1
52.5-2.50-50 % ( RED/NEGATIVE PERCENT)
Example2
A1 B1 C1 D1
2.552.5050% ( BLACK/POSITIVE PERCENT)

Example3
1037.00-70% ( RED/NEGATIVE PERCENT)

3107.00 70% ( BLACK/POSITIVE PERCENT)

Somehow I seem to think I need to use the Value of C1
( which is required btw) to get a percent in D1, but not sure how it
would go in one complete formula in D1

View 9 Replies View Related

Calculate Best 50 Percent Of Customers?

Jan 22, 2014

Making a customer analyse and now I want to know which customers are resposible for 50 % of my revenue.

View 4 Replies View Related

Make Numbers A Percent Of 100

Nov 4, 2008

I have a spreadsheet with a large list of plants. Each plant has a breakdown of colors by container size. Each cell contains a number that corresponds to a percent, e.g. a cell may contain the number 20, which would also mean this number is equal to 20%. I want to change all numbers to a percent of 100, or turn 20, for instance, into .20. There are many hundreds of numbers that I need to make a percent, so I was hoping I could do this in one fell swoop somehow. This percent number will be used in another spreadsheet for calculating on order. How do I do this?

View 2 Replies View Related

Calculate Probabilities In Percent

Dec 8, 2008

I have had a fascination with the lottery, purely hobby, and have had lots of fun over the years working different things out. The last 6 months though I have become fascinated with roulette & thought it would be a fun project to work out all sorts based around that, plus I don't have to wait for lotto results I can get instant numbers & results, however my latest attempts are hitting a brick wall!

I am trying to work out (in percentages) the increasing & decreasing % of 3, 11, 12, 22, possible outcomes

I have worked out the 2 possible outcomes initially for odd/even as follows

At the start they both have a 48.65% chance of hitting, then whatever is hit first the percentages are 76.33% and 23.67%. If you have 2 in a row of odd/even then the percentages are 88.49% & 11.51%, 3 in a row would give you 94.40% & 5.60% etc.

I have used the following formula for this (BM5 is where the totalhits for even are calc'd) ...

View 11 Replies View Related

Formatting Cells As Percent

Jun 18, 2013

I am copying from a cell that has 100 (number stored at text) and want to display in a number format (100%) I keep getting 1000%. I've checked the format to ensure it has 0 decimal places. I've tried formatting the cells as a percent. Still no luck.

View 5 Replies View Related

Percent Change Calculations

Dec 8, 2006

I want to calculate percentage changes, but sometimes my values are negative. Using the traditional (latest-first)/first I'm getting incorrect percentages because of the negative values. How can I write one formula that corrects for this?

View 9 Replies View Related

Calculating Percent Differential

Feb 19, 2007

I am looking to find a formula that will calculate a % differential between two values so for example,

In D3 there is a value of 20%, in D4 there is a value of 40%. The formula should therefore display 100% in D5.

View 3 Replies View Related

Sum Based On Percent Of Another Column

Oct 25, 2007

I have two columns of numbers and want to write a formula that will sum any row in column A that is greater than 75% of the corresponding row in column B. I have tried using (SUMIF(D3:D89,"<0.75*(H3:H89)")) but am not getting any results.

View 2 Replies View Related

No Calculation Flag, And Percent Formula

Nov 13, 2009

1. In neighborhoods that have zero units in a given price range I have it to display "-" , because this unit is not actually zero, the data is not available. Therefore a #VALUE! is displayed for the percent because it cannot calculate the "-". How do I get excel to glance over "-" and flag it for no calculation?

2. For the percentages I am having to manually do them row by row. I would like to set it up in a manner that allows me to copy the formula down by column and across by row correctly.

For instance in the percent for Mira Lagos I have =B4/N3 where b4 is the units for mira lagos and n3 is the total. I can drag that formula across by rowto get all the correct percentages for mira lagos price ranges only, but I cannot copy this formula down by column to any of the other neighborhoods. In otherwords I have to do a new formula for each subdivision.
e.g.

Grand Peninsula=B5/N3
Meadow Glen(Mansfield)=B6/N3
...etc

Again I would like to make it so I can copy the formula across by row and down by column so excel will automatically compute it.

View 3 Replies View Related

VBA Userform – Convert Number To Percent

Feb 12, 2010

In the attached sample (with macros enabled), you will find the problem when pressing the button “INDTAST DATA” (I apologize for the linguistic challenge, but the XL-sheets are in Danish… To relief – check the crash course in Danish below) and then entering some number in the two last textboxes (called “Forventet ændring i antal timer I næste kvartal (%)” and “Forventet ændring i omsætning i næste kvartal (%)”)… If you enter something there, the result will be multiplied by 100 in the worksheet.

I would like to be able to simply enter a full number – like 12 or 9,5– which will then be entered into the worksheet as 12% or 9,5% (and not 1200% or 950%)… I think the answer lies in inserting some code in the VBA code, when the macro writes the data to the worksheet, but you guys know more about it than I do...

I can, of course, enter a full number in the textboxes – followed by a %-sign, but that will slow down the process significantly as well as increase the risk of errors…

Virksomhed = Company
Kvartal = Quarter
År = Year
Branche = Industry
Fakturerede timer = Billed hours
Faktureret omsætning = Billed revenue
Timeforventning = Expected hours (next quarter)
Omsætningsforventning = Expected revenue (next quarter)
Indtast data = Enter data

View 4 Replies View Related

Percent Change - Different Formula Results

Nov 21, 2012

In Excel, what is the reason for different results using the two formulas below?

Example:
Cell L6: 1413.5
Cell M6: 1312

Using the formulas below, the format of the cell is Percentage, one decimal place but I get different results

Formula 1: =-(1-L6/M6) The result is 7.7% change

Formula 2: =SUM(L6-M6)/L6 The result is 7.2% change

What is the difference in the formulas?

View 2 Replies View Related

Parentheses For Negative Percent Results -

Jul 15, 2002

I have been able to format single cells to display negative percents (Budget to Actual hours), but I cannot copy the formatting to cells with positive percents without eliminating the format style I want. [I need to display, with the parenthesis, (13.6%)for negative results, but say, 18.6% for positive results.] When I copy the correctly formatted cell (13.6%) to another cell with a positive result, it sets the display to general formating.

As I have over 25 rows of data to compare against 62 projects and 12 programs, with each value potentially changing from one analysis to the other, I am looking for a method to automatically change the "look" of the results. I have looked at conditional formatting, but have had no indication this will do what I am looking for.

View 3 Replies View Related

Convert Number To Percent Format

Dec 18, 2008

I have built a spreadsheet that pulls data into B60:AA240 (Sheet name is "Actual Numbers Report") from a different sheet in the same workbook. Some of the data is in Number format and the other is in Percent Format. What I would like to do is if AL10 in the Actual Numbers Report sheet says "Actual Numbers" then I would like the cells in B60:AA240 convert to a number format "000,000,000" If AL10 says "Trends" then I want it to convert the cells in B60:AA240 to a percent format "0.0%". I tried creating some code, but it doesn't seem to work.

Private Sub Convert_Percent()
If Not Intersect(Target, Range("B60:AA240")) Is Nothing Then
If .Range("AL9") = "Actual Numbers" Then
Range("B60:AA240").Select
Selection.NumberFormat = "000,000,000"
ElseIf .Range("AL9") = "Trends" Then
Range("B60:AA240").Select
Selection.NumberFormat = "0.0%"
End If
End If

End Sub

If this can work then the 2nd question I would have is can this same line of thinking work to format the chart that this data is pulled from? So if it is Actual Numbers the chart would be in a number format and if it is Trends then it will change to a percent format?

View 9 Replies View Related

Find Duplicates Within A Percent Tolerance

Oct 26, 2008

Below is a short segment of my excel spreadsheet:

A B
1020.00242-89.84
1020 -88.11
1021 -85.3
1021.494-80.41
1021.49 -86.98
1030.04 -89.4
1030.042 -88.26
1030.94 -79.98
1030.933-81.5
1030.961-85.87
1040.0418-88.77
1040.391-87.3
1040.291-82.94
1040.016-84.12
1049.82 -84.7


What I need to do is write a macro that will find duplicates in Column A, within a changeable tolerance, say 0.1 (10%).

After finding all duplicates within a tolerance in A, I need to make another "Master" worksheet with the Duplicates from A, and their counterpart in B. So if A1 and A4 where within 10% of each other, the "Master" worksheet would contain:

A1 B1
A4 B4

using the values, giving:

1020.00242-89.84
1021.494-80.41

I tried using SUMPRODUCT and some other functions but just can't seem to put my finger on this one. I'm sure it's not hard and am overlooking something.

View 9 Replies View Related

Calculate The Percent Of People Within Age Range

Aug 14, 2006

In the demographics sheet, I have ages listed from row F2 to F31 with different ages. I would like to get assistance with a formula that calculates the percentage of people within these age ranges:

21-25
26-30
31-35
36-40
41-50
51-59
60+

It should be separate formulas. I'm sure if I'm given the first and last ones that I could do the others myself. Also, if I needed to know the percent of males and females, would i use the same formula?

View 9 Replies View Related

Calculate Percent Of In Pivot Table

Sep 9, 2006

looking for a way to run some pivot tables on a large data table. Would like the result to show some different data extraction from the same field / column. The table is customer survey results for my employees, and the fields in question can have values from 1-5. I would like to finish the pivot table with all of these fields:

Row: Name (ok, that part is easy)

Data fields:
% of entries (column 2) that are 5
% of entries (column 2) that are 4 or 5
% of entries (column 2) that are 1 or 2
# of entries (column 2)
% of entries (column 3) that are 5
% of entries (column 3) that are 4 or 5
% of entries (column 3) that are 1 or 2
# of entries (column 3)

I'm hoping this is something I can do with calculated fields, but haven't been able to figure it out. So far all I have is a 'Count' function in the pivot wizard for the # of entries, but I'm not getting the % of entries at all. Column A = Name, Column B = 1st metric, Column C = 2nd metric. Fairly simple layout, but I have a small sample file I can attach if that's not explanatory enough.

View 7 Replies View Related

Average Based On Percent Deviation Of Two Cells?

Apr 14, 2014

I'm calculating meter data in 5 min intervals B column is primary meter data C column is secondary meter data B and C are averaged in D using

=AVERAGEIF(B3:C3,">0")

I'm using AverageIf ">0" because one of the two meters is regularly removed from service for calibration, in which case I don't average, I'll only use the online meter reading.

Now I have to figure out how to average B3 and C3 only when the deviation between the two is <10%, and or if >10% to use the greater of the two values.

The examples are B12, C15,18,19...

View 10 Replies View Related

Formula For True/false Tolerance Percent

Aug 7, 2009

I need to be able to get a true/false from a tolerance percent.

Here is an example of what I am trying to do

cell a2 is Nitrogen
cell b2 is (Known gas%) 2.4800%
cell c2 is (unknown gas%) 2.4963%
cell d2 is =b2-c2 and I get the answer no trouble there. what I need is to take the answer in cell d2 and set a plus/minus 2% tolerance in cell f2 and get a true/false comparison.

View 4 Replies View Related

Macro For Progress Bar In Status Bar As A Percent Of Time

Jun 26, 2014

I have been looking for a macro (and have failed to find one) that would give a progress bar in status bar as a percent of the macro run time, e.g

If I had a macro that took say 5 minutes (which I would know in advance) to run is there a way to have a progress bar in status bar that would progress incrementally as a percentage of the 5 minutes or even simpler break the 5 minutes into 1 minute increments?

View 2 Replies View Related

Percent Change Of 100% To Show 100% In Pivot Table Not DIV/0

Jul 9, 2007

I want to make a calculation in a pivot table where a percent difference is calculated by year.

The % difference from calculation does not show an increase from the previous year as 100% but a DIV/0 error. Can i make a custom formula that will use the year base field.

View 9 Replies View Related

Multiply Numbers & Return X Percent Of Result

May 30, 2009

I have an inherited formula and I am not sure if it is giving me the correct answer. It is:

=0.03*668*0.75*0.10
The result is 1.503

What I am aiming for is to get 3% and 25% of 688, deduct the results from 688 and then get 10% of that answer.

Is the inherited formula correct?

View 3 Replies View Related

Formula To Calculate Percent Difference Between Last 2 Columns

Feb 14, 2007

See attachment. In this example, in Column D I want to calculate the percent difference between the numbers in the last 2 columns (Column B and Column C). BUT I want a formula that will automatically update if I were to insert a new column between Column C and Column D. So as a result, new numbers would go in Column D and the percent difference would now be in Column E.

View 2 Replies View Related

Percent Formatted Data Entry Field Occasionally Multiplies Value By 100?

Jun 10, 2013

I have a data entry field on a form that is formatted for percentages. Sometimes when i key in "10" it will correctly convert it to "10%" but other times it randomly converts it to "1000%". When the error occurs, I'm able to correct it by re entering the value a few times until it displays correctly as "10%".

View 2 Replies View Related

Formula To Calculate Percent Change, Varied By Amount Of Months

Jul 24, 2009

I need to figure out a formula for cell F17 that will calculate a percentage change only for the months that have data in 2009. The way it is set up right now I have to go in every month and change the cell reference of the formula to include the latest data. Since the 2008 data is totally populated the formula gets messed up if I include the months of 2009 that have not yet occurred.

View 2 Replies View Related

Calculate Amount Of Days Paid In Advance And Apply Percent Discount

Jul 13, 2009

Part of the assesment task is to write a formula, to work out how many days in advance the customer paid, and then apply the needed discount. I have tried several basica variations to the formula, and keep getting the same Err message.
give point me in the right direction to how i can calculate amount of days paid in advance and apply a % discount?

attached is the start of the assesment question.

You should create and enter formulas to calculate the No. of Days paid in Advance, the Discount and the Course Fee Paid.

Use a VLOOKUP function in your template to determine the discount rate to be used for the calculation of the Discount. Your template should include a separate discount table containing the following information about the discount received:
• If students pay the course fee less than 7 days prior to the course commencing then they receive no discount.
• If students pay the course fee 7 to 13 days prior to the course commencing then they receive a discount of 5%.
• If students pay the course fee 14 to 20 days prior to the course commencing then they receive a discount of 8%.
• If students pay the course fee 21 days or more prior to the course commencing then they receive a discount of 10%.

View 6 Replies View Related

Calculating Cost Per Second

Oct 25, 2007

I'm trying to make a worksheet where I can calculate the cost of a mobile postpaid subscription. It is charged per minute and the cost differs depending on which of the 2 available networks the customer is calling to. The first 20 minutes are free, not depending on network.

Edit:
Charges to network A is 1,79,- per minute after the first 20 minutes are spent.
Charges to network B is 2,29,- per minute after the first 20 minutes are spent.

To sum up:
1. The customer makes a call.
2. If there there are available free minutes, these should be spent first.
3. The customer is charged per minute, depending on network called.

View 14 Replies View Related

Calculating Cost

Apr 17, 2009

Problem - billing spreadsheet for prisoner fee.

1 - 8 hrs = $55
9 - 24 hrs = $55 + $65 or $120
Anything over 24 hrs - $65 for each additional (24 hrs) ($185)

So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250. Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay. I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.

View 5 Replies View Related

Cost Per Row Of Data

Mar 6, 2014

I have an excel table that among other fields it has a [product Charge] field.. what im trying to do is to get a cost per row based on the [Product Charge] field.. so example if I have 10,000 rows and the total for that field is 1,000,000 the cost should be 100 ( [Product Charge] / total rows).... I then want to be able to use it in a pivot table...

View 1 Replies View Related

Least Cost Routing

Aug 3, 2009

im working on a VoIP company, and having a hard time to figure out a result on a little time.

the problem is finding a "least cost routing" wherein you will find the cheaper to higher price, and putting the results on a designated columns:

I am including an image, sorry if the image seems to be heavy and large:

as you can see: Column C contains the sale rate for the client, while Columns D to I, are the buy rates from our source carriers.

While the columns K to P, are the columns where should one source carrier should be fitted base on the buy rates, that is best fitted to the sale rate.

Red marks=are not suitable or non-profitable buy rate for the sale rate.

Sorry for the bad english, but i hope you get what i mean. this is only a sample from our Internal data.

View 9 Replies View Related

ADVERTISEMENT