Cost formular

[Budgie01]

I have written a multipal spreadsheet with lookup fomulars etc. wish to automate and am stumped on one last formular.

<TABLE style="WIDTH: 284pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=379><COLGROUP><COL style="WIDTH: 109pt; mso-width-source: userset; mso-width-alt: 5148" width=145><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2531" width=71><COL style="WIDTH: 65pt; mso-width-source: userset; mso-width-alt: 3100" width=87><COL style="WIDTH: 57pt; mso-width-source: userset; mso-width-alt: 2702" width=76><TBODY><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 109pt; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19 width=145>Cost</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 53pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=71></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 65pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" width=87></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; WIDTH: 57pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl8729 width=76> 850.00 </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19>GP</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0"></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl8730 align=right>25.1%</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl8729> 213.00 </TD></TR><TR style="HEIGHT: 14.4pt" height=19><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; HEIGHT: 14.4pt; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" height=19>Selling price</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl8732></TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl8730 align=right>20.0%</TD><TD style="BORDER-BOTTOM: #f0f0f0; BORDER-LEFT: #f0f0f0; BACKGROUND-COLOR: transparent; BORDER-TOP: #f0f0f0; BORDER-RIGHT: #f0f0f0" class=xl8731> 1,063.00 </TD></TR></TBODY></TABLE>

Above I have a variable cost cell, the selling price is currently manually inputted, through selecting a number so that the markup = 20%, which inturn gives me a GP percent and value.

Would be great to have a table and formular so that a number could be choosen and i equal to 20% automatically inputted

 

[Peter_SSs]

Welcome to the MrExcel board!

Do you mean something like this? Formula in B2 is copied down.

If not please try to give more detail about what you have and what you want to achieve.

Excel Workbook
	A	B	C	D
1	Cost	Selling price		20.00%
2	850	1062.5
3	250	312.5
4	2000	2500
5
Markup

 

[Budgie01]

Hi Peter

A B C
1 Cost $ value
2 GP +C2/C1 +C3-C1
3 Sell price +C2/C3 need a formular

Suspect the formular needs to look up a range of value i.e.

100
110
120
130
etc

suspect formular needs to lookup, if first cell is incorrect move on to 2nd cell and so on until = maybe a drop down % i.e. choosen value.

I keep getting circular formulars1

I could e-mail you the shpreed sheet or talk on skype.

many thanks

Mickey

 

[Peter_SSs]

Sorry, I don't understand what you are wanting.

In relation to email/skype, that would defeat the purpose of this being a public forum and would breach #7 of the Forum Rules.