ratio

Ciao All ~ Is it possible to generate / create a sequence of binary numbers, that cannot repeat more than twice, based on an entered ratio x:y? if not a ratio, than perhaps two percentages equal to 100%? For example, a 2:1 ratio would generate a 12 cell pattern of : 1,1,0,1,1,0,1,1,0,1,1,0...

Love posting on this forum due to the assistance, explanation, and time that others put into helps us noobs. So I thank you in advance. Ok, so I need to find the percentage of some data that I have. The simple equation would be: Total Number of Events w/in 30 days of Date1 while Date2 is...

Hi to all i am using the below code to insert a picture in excel. the code works and i get a picture, but i how like to size the picture to a fixe width and maintain the aspect ratio. Any good suggestions.? Worksheets("Approval Drawing 1").Shapes.AddPicture _ Filename:=myDir &...

I have a formula that I’m using that will return a ratio =IF(N(D11)=0,N(D15)&":0",D15/D11).It works great when I have a number. In this case D11=46 and D15=35 which willreturn 76% ratio if my cell is formatted to percentage or if I use the custom featureand enter 0.0”:1” then it will return...

So I am in a predicament. We have orders that range from $500 to over $500,000 and we charge a certain amount for an extra condition and we want to base that cost off a percentage of the order. The smaller orders we charge 2% and the max we will charge will be 0.5% at $500,000. Anything in...

I've looked through different posts but do not see a solution to this question that seems to have plagued Excel since day 1. All I would like to do is insert an image (our logo... simple jpeg... see images below) into a spreadsheet. I do and it looks great. I lock the aspect ratio. Then when...

So I have 4 catagories for care provided to a disable adult, for accessing the community there could be a 1:1 staffing ratio, for personal care this could be 2:1. For group work this staffing ratio could be 1:10. I need 4 areas to have a drop down selection of a a ratio. Then I need to...

I'm trying to find the ratio between three very small numbers: Mass of Nitrogen D1 = 1.00x10-4 Mass of Phosphorus E1 = 2.04x10-6 Mass of Chlorophyll F1 = 7.71x10-6 Total mass H1 = D1 + E1 + F1 = 1.10x10-4 I'm attempting to show whole numbers, but I'm not sure if it is feasible. The first...

Is there any way to have excel display a ratio. I am looking for a ration of B31 and B32. I would like it to display as "3 to 1" or "3 -1" does anyone know of a way to do this?

<tbody> A B ratio 17 14 1.21 6 11 0.55 5 16 0.31 5 18 0.28 3 0 #div/0! 12 17 0.71 0 12 - 12 8 1.5 3 10 0.3 4 2 2 median 0.55 </tbody> i want to calculate the ratio of two set data..then find the median of that...

Hello, I am trying to calculate a ratio for Hours per Ticket by month. I have a pivot table that COUNTS tickets and SUMS hours per month. I was hoping to create a calculated field to the jist of COUNT(Tickets) / SUM(Hours), but this does not work because calculated fields aggregate data.... I...

Hi all, This is more of a math question than an Excel question, but hopefully some folks have a solution and enough people are interested. Here is the situation, as simplified/generalized as I can make it. I have clients that pay a contractual periodic fee. It is a dollar amount, but can...

Hi. I have just discovered Power Pivots. I think DAX can solve an issue I have with regular Pivot tables. I have to create a report that divides all amounts for a given month between the total income amount for that month. I almost get it with a regular Pivot Table...

Hi there, I have a pivot table that has the following populated: Row = Week 1 to Week 5 Column = Values Values = Count of Customer, Sum of Sales I am trying to establish the ratio between the number of customers and the number of sales on a Pivot Table, and what is the best way to display the...

Hi all, This is a "hand me down" worksheet. The author created a column they intended to display as ratios (e.g.; 1:3, 2:16, etc.) However, Excel "knows" that they must have meant these were really "time" format. So, the 1:3 "ratio" is stored in the cell as "1:03:00 AM". The 2:16 "ratio"...