Custom Formula Question

[andrnick7]

Hey peeps,
I just have a quick question and I know this is going to sound ridiculously simple and I apologize if it is - I'm a bit new to Excel formulas. My question is this: I'm trying to create a formula that takes into account a certain price, adds fees (percentages + fixed fees + taxes) to that price, and then marks up that sum by 50%. Then, in another cell, I'd like to compare that price to the selling price and calculate the profit margin.

This is what I've done so far: Screenshot by Lightshot. Here's a breakdown:

• 1st cell: Retail Price
• 2nd cell: Wholesale Price
• 3rd cell: Adding Fees (=J2*0.129-0.3 (Second cell, multiplied by 12.9% and I probably should've added the 0.30 cents as it's a fixed fee)
• 4th cell: Total Cost (=K2+J2) (The fees + the wholesale price)
• 5th cell: Difference from retail to wholesale + costs (=I2-L2)
• 6th cell: Do a 50% markup on the wholesale + fees price =((1.5*J2)+K2)
• 7th cell: Determine Profit Margins: (=(M2/I2)*100) (Profit potential/selling price * 100)

I know the format is a bit wonky. It should be: Retail Price, Wholesale Price, Fees, Total Cost, Profit Margins, 50% markup, and difference from retail. But I'm specifically putting the profit margins at the end of the evaluation.

Is there anyway I can condense my steps into fewer cells with a more complex formula? Is this efficient?

Thank you for your time and I hope this serves as a lesson for me and others on here. I'd appreciate if anyone could help me with my problem.

 

[etaf]

you can do the sums with()
i lost my way
whats the first cell

1st cell = what cell reference - is this J2
2nd cell = what cell reference - is this K2
3rd cell is using J2 (is that the 1st cell

instead of M2 - do the calc

as i say , expand the details , so we can see more

 

[andrnick7]

Screenshot by Lightshot

Sorry about that.

 

[andrnick7]

I2 - Selling Price
J2 - Wholesale Cost
K2 - Fees
L2 - Total Costs
M2 - Profit Potential
N2 - Marked Up Sales Price (incorporates fees + wholesale price) by 50%
O2 - Profit Margins comparing profit potential and sales price. This helps me determine if it is a good product.

 

[etaf]

• I 1st cell: Retail Price
• J 2nd cell: Wholesale Price
• K 3rd cell: Adding Fees (=i2-(j2+(J2*0.129-0.3)) (Second cell, multiplied by 12.9% and I probably should've added the 0.30 cents as it's a fixed fee)
• L 4th cell: Total Cost (=K2+J2) (The fees + the wholesale price)

=i2-(j2+(J2*0.129-0.3)) >>>> L

• M 5th cell: Difference from retail to wholesale + costs
• (=I2-(j2+(J2*0.129-0.3)))
• 6th cell: Do a 50% markup on the wholesale + fees price
• =((1.5*J2)+(i2-(j2+(J2*0.129-0.3))) )
• 7th cell: Determine Profit Margins: (
• =I2-(j2+(J2*0.129-0.3))) /I2)*100) (Profit potential/selling price * 100)r

• may have some brackets wrong - but do you see how i have built up from just
• I2 and J2

if you put a sample file with the results you expect on dropbox or onedrive , then we can work more accurately

 

[andrnick7]

You don't happen to have a Skype do you?

 

[etaf]

yes, but all support needs to stay on the forum only - see the rules

 

[andrnick7]

Ah ok, sorry about that. Let me upload it.

 

[andrnick7]

https://drive.google.com/file/d/0B83-i7BCKRWbbmpBSHBoU2VhTlE/view?usp=sharing (Sorry if this isn't one drive). And yes, I do see the build up. That's quite awesome. Very well done on that!

 

[etaf]

everything made up of a2 and b2
https://www.dropbox.com/s/c1w8w23xaj00w7z/Expected Result_etaf.xlsx?dl=0