Profit Formula

[robvpp]

I'm trying to Total a Single Product Profit: =((Cost+11% (Overhead)+Transaction Cost (default to 5, if not higher than 5))*25% (Taxes) ))*40%(Profit))

5 being a minimum of 5 Dollars. Here is the Non-Excel Formula I came up with that isn't working:

Non-Excel Formula: =((Cost+11% (Overhead)+(Transaction Cost if higher than 5)Minimum 5)*25% (Taxes) ))*40%(Profit))
Excel Example: =(1*(((F9+(F9/0.89-F9))+1*(F9*K6+L6))MAX(5))*25%)/0.6

Obviously, right now it's a mess. Any help would be appreciated.

Thank you in advance.

 

[robvpp]

I'm trying to create a Formula for: (Product Cost+Transaction Cost+Taxes Cost)*Profit=(however = must be a minimum of 5$)

If anyone could let me know about the following:

Final Formula (except the $5 Minimum doesn't work/factor): =((F9+((F9/0.89-F9)+((F9*K6)+L6)+((((F9+(F9/0.89-F9)+((F9*K6)+L6)*0.25)))))/0.6))*MAX5

Screenshot:

Excel Sheet:

Factors	Cost	(+)	Overhead	(+)	Transaction Cost	Taxes	(+)	Profit	(+)	MAX5 (it doesn’t have to be MAX5, just whatever the formula creates to have the Amount be a Minimum of $5)
	0.029%	$0.30
Cell	B4		N/A		B1	B2	N/A		N/A
Cost	$0.50		N/A				N/A		N/A
Formula:			B4/0.89-B4		(B4*B2)+C2)	(B4+(B4/0.89-B4)+((B4*B2)+C2)*0.25)		(B4+((B4/0.89-B4)+((B4*B2)+C2)+((((B4+(B4/0.89-B4)+((B4*B2)+C2)*0.25)))))/0.6)
			$0.06		$0.30	$0.64		$2.16	$5.00 (Total should be a Minimum of $5)

Again, any help would be greatly appreciated.

 

[Dave Patton]

What is your Max5?

Please review post #6. Without clear information, I cannot provide much help!

T202310a.xlsm
	C	D	E	F	G
8	0.2	0.5	0.6		5
9	150	200	300		650
3g

Cell Formulas
Range	Formula
G8:G9	G8	=MAX(5,SUM(C8:E8))

 

[robvpp]

Hi Dave,

I appreciate you getting back to me. On either your, or my, format it would probably be best if we used small numbers since that is the basis of what the *MAX5 is.

This should be easy to test by just doing a New Sheet/Tab using these fields/numbers:

A1: Cost ($0.05)
A2: +Overhead (11%)
A3: +Transaction (($0.029 of A1)+$0.3)
A4: +Tax (25%)
A5: Total: ($2.19)

All of the above I get with this Formula: =(A1+((A1/0.89-A1)+((A1*A3)+.3)+((((A1+(A1/0.89-A1)+((A1*A3)+.3)*0.25)))))/0.6)

What I don't get, or can't figure out is, how I make the $2.19 default to $5 as a minimum? Whether that be *MAX5 of other Formula doesn't matter to me as long as the Formula gives $5 as a minimum result.

I hope this helps?

Thanks again,
Rob

 

[Dave Patton]

Did you try the suggestions?
I am not aware of a regular function named max5.

try =Max(5,(A1+((A1/0.89-A1)+((A1*A3)+.3)+((((A1+(A1/0.89-A1)+((A1*A3)+.3)*0.25)))))/0.6))

 

[robvpp]

Hi Dave,

That's it! It works perfectly!

I can't thank you enough,
Rob