Figuring A Percentage

Jul 7, 2008

Store A sells something for 100

Store B sells the same item for 125

Store B is 25% higher than A

how would a formula be written to show that?

Store B / Store A = 1.25 How do I get it to 25%

View 9 Replies


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

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

Figuring Out Which Function To Use For Scenario

May 14, 2008

Need constructing a formula and im not too sure which function to use.
Im also not sure if its even possible or im missing a required column to help make it possible.

(arrival Time)---(c1)--(c2)--(served by)---(time served)---(exit time)
-------A---------B-----C--------D----------E----------------F
1----9.00am-----0-----0--------1----------2mins-----------9.02am
2----9.01am-----1-----0--------2----------15mins----------9.16am
3----9.05am-----0-----1--------1----------2mins-----------9.07am
4----9.06am-----1-----1--------?----------xmins-----------x.xxam

Column A = Arrival time
Column B = Number of customers in Counter #1 as of arrival time
Column C = Number of customers in Counter #2 as of arrival time
Column D = to be Served By Counter:
Column E = Mins being served before exiting the counter/que
Column F = exit time
rows = customers entering a que.............

View 9 Replies View Related

Figuring Out And Then Converting A Timestamp In Excel?

Jul 3, 2014

I received some time stamped data in this format: 06.08.06.000000000 PM.

convert to HH:MM:SS ?

View 7 Replies View Related

Figuring An AVERAGE From 4361 Cells

Aug 3, 2009

I Need figuring an AVERAGE from 4361 cells... looking to get a blended rate on pricing.

I am not even sure if excel can avg that many cells.

View 4 Replies View Related

Creating Spreadsheet - Figuring Cost Of Favorite Recipes

Nov 3, 2013

I want to create a spreadsheet for figuring the cost of some of my favorite recipes. Right now I have a table of basic ingredients (milk, sugar, etc) along with cost of same.

What I want to do is be able to set up a recipe that calls for "3 eggs, 1 sugar, 1 milk" and automatically figure the cost for me.

Ideally, I'd like this to be a "building block" spreadsheet - where I can have a recipe for "roux" (1 flour, 1 butter), and then a recipe for "broth" (1 chicken, 3 water), and then a recipe for "gravy" (1 roux, 2 broth) - where the spreadsheet is smart enough to do the math for me - and if the price of chicken goes up, I can change that in my basic list and it will carry down. And obviously, I want to be able to add ingredients and recipes easily.

View 3 Replies View Related

Conditional Formatting Based On Percentage And Insert Cell Based On Percentage

Apr 3, 2013

I have a workbook that I've built for a project. I've attached a sample workbook. What I'm trying to do, for the entire sheet or workbook if possible, is turn any Cell with a percentage of 30% to 49% yellow and any cell with a percentage of 50% or more Red. I would also like to move the ID's of the variable cells, for example Id number 9922, to the cells beside the description of the rows, Affected would be an example, if the information contained in the same row as the ID meets with a set of variables.

For example I only want the ID's moved if they correspond with IDsub 1-25. One more thing, the people who will be using this spreadsheet will be copying data from a website when it is imported it does not insert the values as numbers. I would like to format the cells, in example workbook they would be any of the cells labeled ID IDsub Variable or Number, so that anything put in that cell will automatically be converted to a number.

I should also probably add that the formatting will be done on approximately 80 rows a sheet with 47 sheets.

View 2 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

Toggle Between Percentage And Value?

May 26, 2014

How can I toggle between percentage and actual value to display on a pie chart?

View 1 Replies View Related

Add Percentage To Value - Display At X

Apr 8, 2014

I have a whole number (207) in B5. This should be seen as a percentage (207%).

I want to add this percentage to the value in M15, which is not a percent (2705.8).

I would like to display this sum in M17.

The number that is displaying now, after simply putting 207% (I don't want the % symbol in there) in B5, and the formula =sum(M17,B5) in M17 is 270787%.

This is obviously not correct.

View 3 Replies View Related

How To Round Up A Percentage

May 5, 2014

Why is Excel not rounding up a percentage of 93.5 to 94?

View 6 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

Twice Percentage Cell?

Dec 16, 2013

The cell I am referencing value is 100,000

I need to take two percentages off of that number. First 50%, then 37% and have the value in a SINGLE cell.

Because 100,000/1.87 is not the same thing....of course.

View 11 Replies View Related

YTD Percentage Formula

Mar 6, 2008

Is there a formula that I may use to keep track of the YTD percentage of attendance of volunteer workers over the course of a year? I have approx 200 workers meeting once a week. Their names are listed in column "A" from A-4 to A-204. Starting in column "E" is the date of the weekday for attendance.

For Example: E-1 is dated Jan. 7, 2008. F-1 is dated Jan. 14, 08 etc. I place a one (1) in the corresponding cell to show that they attended. The formula I need would start in cell D-4 and be dragged down to D-204.

There also must be a way to factor in the weeks which we are to meet that must be cancelled due to weather etc. The worker should not be penalized due to our cancellation.

View 11 Replies View Related

Add Percentage To Numbers

Nov 25, 2008

I was wondering what the formulas was for adding 20 percent to a price of lets say 10.00. What would I use for this?

View 2 Replies View Related

Percentage Display

May 13, 2009

I've seen a few finance excel sheets lately (don't have an example right now... ) that have a total number for something and then in parentheses next to it a percentage of the total is automatically calculated. So I have 5 pens and that's 10% of what I have in my pencil cup --> 5 (10%) is how it is displayed.

View 3 Replies View Related

Percentage Of A Value After Filtering

Sep 17, 2009

I would like to know whether it's possible to evaluate the percentage of a text value ie 'Approved', after filters on other columns have been done.

AREA YR DECISION

HN 09 APPROVED
NYM 08 REFUSED
RC 09 APPROVED
HN 09
RC 08 REFUSED
? %

So if I filter by AREA and/or YR, I would like the % of how many were 'Approved' in that filtered range (ignoring any blank cells in the DECISION column).

So far I have a basic
=TEXT(COUNTIF(C2:C6,"*Approved*")/ROWS(C2:C6),"0% ""Approval Rate""")
but it doesn't work once I filter by AREA or YR, and doesn't ignore blanks.

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

Percentage Value In Scroll Bar

Aug 23, 2009

I've been trying to set the scroll bar min/max/small change to a decimal (percentage value) within the properties, obviously this does not work.

Since users can enter a value in the link cell for the scroll bar, how can I modify the current min/max/small change via macros so the scroll bar will show a min on 1%, small change of 0.25% and max of 25%?

View 14 Replies View Related

Percentage Function

Feb 18, 2006

I m having several problems and we will start with this one first. OK, we run machines for an 8 hour shift and these machines are down or not running for a few hours out of the 8 hour shift. I want to be able to put a number in a cell called "Delay" lets say 4:00 hours to make it easy and in the next cell over called "%" I want it to give me the % that the machine wasnt running for the 8 hours. The answer is 50%.

View 9 Replies View Related

Negative Percentage As Zero

Feb 17, 2009

i have for example column I, J & K. col I and J has both negative & positive values and K (I/J) works out the %

Col I Col J col K
135975 583333 23%
-27748 583333 -5%
-18186 583333 -3%
272550 583333 65%

But i need a formula or formatting that always shows the negative percentage as a zero.

View 2 Replies View Related

Percentage Formula..?

May 7, 2009

I have a simple spread sheet where i need a formula to work out a percentage. eg total cases 35246 number of errors 3. what percentage is the 3 of the total cases and what is the formula required to reflect the answer.

View 3 Replies View Related

Percentage Complete

Jul 15, 2009

I have an issue new client is asking for me to present my reports with a percent complete. We do survey work and all our date is in Ft. The way my file is set up right now i have H5-H100 as incomplete footage, Column I5-I100 has my completed footage and to keep it simple Row 13 A-k show total amount of footage. He wants to see everyday when i submit the % complete based of footage incomplete and footage completed.

Anyone able to help me out with a formula for this? I tried messing with it a little, wasn't really able to get it down and my Excel skills definitely aren't past beginner level.

View 6 Replies View Related

Percentage Changing The 0

Aug 16, 2012

=IF(AE6="","",LOOKUP(AE6,{0,0.8,0.9},{"Failed SLA","Borderline SLA","Passed SLA"}))

The above formulae I have works but this changes this to failed when a 0 is shown in the field.

This 0 is shown in the field this is due to the item having no data how can I cahnge the formulae so the cell stays blank

View 6 Replies View Related

Percentage Above Or Equal To A Value?

May 30, 2013

I have 31 cells in a row (one for each day of the month. we collect data in these cells by typing "y" or "N". based on these input, cell 32 calculates the percentages based on total of Y's. Cell 33 has goal percentage. So, if the goal percentage is 30, Is there a way when a "y" or "n" is entered in cell 25, if the data percentage is = or 5% above the goal to get text message saying "good" but if the data percentage is 5% or more below goal, get a "not good" message?

View 3 Replies View Related

Increase In Value Due To Percentage

Sep 5, 2013

I have a sheet comprising of 4 columns, laid out like the below ;

A4 = Equipment
C4 = Cost
E4 = Revenue
G4 = Gross Profit

I require to enter a percentage into the gross profit column, and for this to interact with the cost column, then for the revenue column to return the total of the cost including the profit.

View 3 Replies View Related

Concatenating With A Percentage?

Apr 9, 2014

I have a table where a field is called "Expected conversions at [X%]".

X% is a monthly calculation.

So to populate the table row name I tried ="Expected Conversions At"&" "&C28 where C28 refers to a percentage calculated elsewhere in the sheet.

Cell C28 is formated to 1 decimal place. But when I refer to it in this manner it displays to many decimal places.

The result:

Expected Conversions At X.XXXXXXXXXXX

It should say:

Expected Conversions At X.X%

How do I do this so as the % is dynamic and auto updates each month?

View 2 Replies View Related

Percentage Formula

Mar 26, 2008

how to construct a formula that would give the amount of deposit needed initially that would equal, after an immediate percentage reduction, a certain amount.

For example, if the initial deposit was immediately decreased by 2.9 percent and 30 cents (as in a PayPal transaction), what would that initial deposit have to be to equal exactly 50 dollars after being reduced?

View 9 Replies View Related

Percentage Split

Apr 23, 2008

I have the following cells:

A1: the percentage difference between cost1(D1) and cost2(C1)
B1: total product cost (C1+D1)

I need a formula that no matter if the %diff increases or decreases this would reflect in C1 and D1 (so basically C1+D1 would always add to B1 but with the split of % in A1)

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved