..help calculating cost of goods

[Jeni.Black]

I am trying to calculate the cost of goods and can't seem to get the formula correct in excel to get the correct result. Here's the formula...can you help me format it? Thanks!!!

= cost of goods + $1.20 x 12 + $15 / 12 = cost with printing then multiply it by 1.6 for the final result.

Anybody?!?! Thank you!!!!

 

[MrKowz]

What is your input and desired result? Would this fit your needs?

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style=";">Cost of Goods</td><td style=";">Final Result</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;;">50</td><td style="text-align: right;;">83.92</td></tr></tbody></table><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style="background-color: #E0E0F0;text-align: center;color: #161120"><th><b>Sheet1</b></th></tr></td></thead></table><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B2</th><td style="text-align:left">=(<font color="Blue">(<font color="Red">(<font color="Green">(<font color="Purple">A2+1.2</font>)*12</font>)+15</font>)/12</font>)*1.6</td></tr></tbody></table></td></tr></table><br />