margin

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...

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?

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...

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...

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...

<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...

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?

<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>...

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...

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...

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...

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)...

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...

<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...

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...

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...

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.

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

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...

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% =...