Create a Bundle price with Excel

[seansr]

I have a order and I want to show the individual prices but my marking 1 item as a bundle and other items in as included (or some neat presentable way of doing that)that I can show a new bundle price and other row total cost


See example (how that looks ok)


QTY Item Cost price Total price New Total Price

Bundle 1 Main item 1200 1200 1500

inc 1 extra a 300 300 0

inc 1 extra b 90 90 0

inc 1 extra c 90 90 0

inc 1 extra d 75 75 0

1 extra e 45 45 45

 

[SirJB7]

Hi, seansr!


Let me see if I understood. Is this your data? Because it appears a little piled in your post?


-----

[pre]

QTY Item	        Cost price	 Total price	 New Total Price
Bundle 1 Main item	1200	         1200	         1500
inc 1 extra a	        300	         300	         0
inc 1 extra b	        90	         90	         0
inc 1 extra c	        90	         90	         0
inc 1 extra d	        75	         75	         0
1 extra e	        45	         45	         45

[/pre]
-----


If it is, I ask you this:

a) 1500 price includes main item and extra a only? should it include extras b, c and d too?

b) extra e goes apart from bundle? i.e. bundle = xxxx, extra e = yyy


If it isn't, please consider uploading a sample file and how should you display the required output. See second green sticky topic at this forums main page for uploading guidelines.


Regards!

 

[seansr]

Hi SirJB7


basically I want it that anything imedietly under Bundle in column A that says Inc (or something else) the figure in the Total price is reset to zero.

In the example the bundle includes the main item and a, b, c, d but not e.It may be that there are further items in or out of a bundle lower down in the order


I have worked it out with the following

=IF(A4="▲▲", 0, (D4*B4))

Bundle = ►►►

inc = ▲▲


unless you can think of a better way


Kind Regards