margin

  1. S

    Reformatting Margin Data with calculations

    I have put together a very small sampling of test data to show what I am trying to accomplish, but am not 100% of how to go about putting this in action. We have a list of owners that pay a certain percent of margin of sales as a royalty payment. Which if it were just left at that it would be...
  2. P

    Margin ,table

    Hi guyst i used margin left right 0.5 top bottom 0.75 but it looks like this. how can i solve this problem? anyone can help?
  3. J

    Return Lookup based on range cell

    Hi all. I'm renting out construction tools and have my margin at different rates depending on the number of rental days. This is what my days-margin cells look like: <tbody> D E Days Margin 1 1.4 2 1.3 3-7 1.2 8-14 1.15 </tbody> If I have A3 titled "Number of Days", B3 shows the...
  4. D

    I need help with some stock market math

    Here's a link to the table I'm working on. https://drive.google.com/open?id=11xxNJBIXnwgfm8E5Q27U5wF8xbMMPeB_ note: I'm expecting either a 61.8% or a 78.6% Fibonacci retracement so I'm using those percentages. I'm trying to calculate the return of a strategy where you short the coming bear...
  5. S

    Percentages not showing correctly

    Hi, First post so apologies if this has been answered before, I have a margin calculator at take into account a yearly or monthly cost, a possible install and then a sell cost, this then works out a yearly percentage of margin, for 3 years. However the percentages are incorrect and I cant find...
  6. M

    Conditional Formatting - change cell colour and and adding text

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px}</style>Hi, Im trying to use condition formatting to change the cell colour and add some text to the cell. The formula I’m...
  7. I

    How do i calculate margin cost

    My spreadsheet looks like this: <tbody> Total Collected After Shipping & Fees Amber List Cost Estimated Profit Profit Margin $50.36 40.00 10.36 ? $13.35 10.00 3.35 ? </tbody> How do i calculate the profit margin?
  8. J

    hel separating

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}table.t1 {border-collapse: collapse}td.td1 {border-style: solid; border-width: 1.0px 1.0px 1.0px 1.0px; border-color: #cbcbcb #cbcbcb #cbcbcb #cbcbcb ; padding: 0.0px 5.0px 0.0px 5.0px}</style> <tbody>...
  9. J

    If query

    Hello, I would like to know how to create an IF query for multiple criteria. Basically I need to calculate commission based on the following criteria, brand type min margin if the type is used, then look at the sell price the answer to all of these will then need to look to know if what...
  10. D

    Calculate a Percentage of time

    Hello Can somebody help me with this problem i'm having with, im trying to figure out how to determine Time1 is (Time2 - #%), this is an example of the problem : im trying to get a broader percentage like 15%,16%,17% etc to 30%. tried using a simple formula but the result is off by a...
  11. A

    Concatenating text with with time not working.

    Hi Excel experts, I am trying to concatenate text with time. But it is not working. For example <tbody> FOM MY ECC Staging Margin Transaction Daily 01 -Cell 1 <tbody> 0:50:52 - Cell2 Output is coming as <tbody> FOM MY ECC Staging Margin Transaction Daily 01 0.0353240740740741 I...
  12. E

    Horse Racing Strength

    Hello all, I am looking to produce a rating (number) for a horse based on it's previous race strength figures. In the below example the highest race strength is "19" but i want to be able to rate the horses based on Starting price (lowest to highest) and Last Start Margin ((lowest to highest)...
  13. B

    Autofill Run Time Error

    Hi, I created a script to created three separate equations in columns, P, Q and R. I have it working up to autofilling down for P and Q, but am now getting a Run time 1004 error when it tries to auto fill down from R2 to wherever the bottom would be. Any suggestions would be helpful! Sub...
  14. M

    HELP PLEASE! Determine scorre by look at number that is between two cell values

    <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Helvetica Neue'; min-height: 14.0px}</style>Hi, I would like to use a vlookup to determine the effort scope in column L by referring to the table in...
  15. M

    SUMPRODUCT - SUMIF - MULTIPLE TABLES; To Get Results From Single Criteria

    Hi, I can get so far with my formula but not sure how to finish it off. Please help. I have 4 tables, Table 2 / 3 and 4 have data - the first table has the initial criteria and the formula next to it to bring back the result. <colgroup><col><col><col span="3"><col><col><col...
  16. M

    odd issue with field names in Power query formulae

    I have downloaded some date from a website as an xlsx file and for example the field name is "EBITDA margin (%) Last avail. yr" However if I then add a power query command the field name appears as for example = Table.AddColumn(#"Changed Type3", "EBITDA %", each [#"EBITDA margin (%)#(lf)Last...
  17. E

    Formula to input margin % and then have sales price adjusted

    Hey gang, I was unable to find what I was looking for so please forgive me if this is a repeated post. I am looking for a formula that will allow me to input the desired sales margin percent which in turn adjusts the sell price. Any help is appreciated.
  18. N

    need help with calculations

    I am trying to determine a margin based on my total cost of products For example I have multiple line items with a cost I want to add a margin to each line item depending on it range <1000 add 45% margin <5000 but greater than 1001 add 43% margin <10000 but greater tan 5001 add 35% margin etc
  19. B

    Reverse calculate margin

    First time poster and desperate for help! I work in sales spend a lot of my time working out selling prices for my team and me. As a sanity check, I use a spreadsheet (I call my Margin Calculator) to enter all costs and then, depending on the client, the final selling price rather than pen and...
  20. D

    Progressive Price Calculations - % Based

    Hi - Hope you can help I need to add a formula that calculates a margin percentage from a net purchase price (NPP). As the NPP increases, the margin percentage decreases Example of the outcome required NPP is between £00.01 & £10.00 calculate NPP + 200% (NPP = £07.50 calculate £07.50 + 200% =...

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