ratios

  1. D

    Is there a formula to utilize ratios?

    In column A I have random numbers. Column B is supposed to show the amounts of column A but calculated to not deviate more than a certain percent from the average. The total of column A and the total of column B should equal the same amount. For example A1 is 51, A2 is 53, A3 is 55, and A4 is...
  2. S

    Excel Ratios and Comparing Two Cells to Determine Outcome

    I work in a church and I'm trying to determine how to monitor if our rooms with kids/teacher ratios go over the state requirements. For instance, we can have 4 infants with 1 teacher. So, one of our rooms had 5 kids to one teacher and I would like column C to show YES if it is greater than 1:4...
  3. D

    Distributing invoice value in another table

    Hi, Please help me to build a DAX formula to address the following issue, I am planning to use POWERPIVOT to do this work. In the shared link, there are 3 sheets, 1. BlendSheet, 2.Inv, 3. Required output. Blend sheet contain the product mix in various ratios. The objective is to generate...
    • devcochin
    • Thread
    • blend invoice link power pivot measure ratios
    • Replies: 1
    • Forum: Power Tools
  4. A

    How to divide amount in different ratios or percentage? [Simplest Way]

  5. M

    Trying to figure out how to turn a ratio into a number

    Searched around the web and MS help and all I could find is people trying to do the reverse of what I need. So I have a spreadsheet that is exported in a data only method from another program. One of the columns of data provides information in a ratio format, for example "9:1". How would one...
  6. A

    Data reorganisation using ratios

    Hi, I need to do conversions on some data using ratios. (It's based on the reorganisation of spatial boundaries). I cannot figure out how to apply the different ratios to the same case/code (it's a very large database, so doing it individually is not possible) An example of my dataset...
    • AusGirl
    • Thread
    • conversion duplicate ratios reorganise vlookup
    • Replies: 2
    • Forum: Excel Questions
  7. K

    Ratios and #DIV/0 errors

    Hi everyone! First time to post here, but I have enjoyed watching Mr. Excel with Leo Laporte during the old "Call for Help" and "Lab with Leo" television shows...which is why I'm here today in need of this forum's assistance. I wish to thank EVERYONE in advance for your insight and assistance...
  8. Y

    How to do automatic scaling of ratios in excel

    Hello, I have a recipe that uses for example, 3 cup flour 2 cup sugar 3 cups milk 4 eggs And this produces 18 muffins. Are there formulas I could use in excel to scale the recipe up or down automatically? Meaning if I wanted to produce 30 muffins. Could it automatically change the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top