::::I need Help on a "Total Money Spent Formula"::::

[XxCALLofBOOTYxX]

In the following sheet u will see the RED text("what goes here"). What i am trying to find out is how much money i spend total, since they first buy of any of the given properties would be.. If i buy 1 "corner store", notice that the price changes for the next purchase on a corner store, and so on the more you buy they keep going up in price.

Excel Workbook
	A	B	C	D	E	F	G
1	PROPERTY	QTY.	BASE PRICE	CURRENT PRICE	INCOME RATE	FULL INCOME	TOTAL MONEY SPENT
2	LIBRARY	0	$ 10,000	$ -	$ 500	$ -	WHAT GOES HERE?
3	CORNER STORE	1	$ 25,000	$ 75,000	$ 1,000	$ 1,000	WHAT GOES HERE?
4	HOTEL	2	$ 50,000	$ 300,000	$ 2,500	$ 5,000	WHAT GOES HERE?
5	SKY SCRAPER	3	$ 100,000	$ 900,000	$ 5,000	$ 15,000	WHAT GOES HERE?
6
7						Total:	0
Sheet1

 

[XxCALLofBOOTYxX]

Sorry about the lack of info in the last post. I took out some of the columns to prevent confusion...

**PS - you might want to build this in Excel to see it work, as u might get a better understanding of what im talking about and try to figure out...

If anyone has any further questions feel free to PM me. Thanks...

In the following sheets you will see the RED text("what goes here"). What i am trying to find out is how much money i spend total, since they first buy of any of the given properties would be.. If i buy 1 "corner store", notice that the price changes for the next purchase on a corner store, and so on the more you buy they keep going up in price.

***Here is the sheet without having purchased any property yet. (E2 WOULD BE ZERO DOLLARS)

::::EXAMPLE 1::::

Excel Workbook
	A	B	C	D	E
1	PROPERTY	QTY.	BASE PRICE	CURRENT PRICE	TOTAL MONEY SPENT
2	LIBRARY	0	$ 10,000	$ -	WHAT GOES HERE?
Sheet

***Here is the sheet assuming someone was buying 1 "library" (notice current price triples if you buy 2(indicated by "current price") (E2 WOULD BE $10,000 DOLLARS)

::::EXAMPLE 2::::

Excel Workbook
	A	B	C	D	E
1	PROPERTY	QTY.	BASE PRICE	CURRENT PRICE	TOTAL MONEY SPENT
2	LIBRARY	1	$ 10,000	$ 30,000	WHAT GOES HERE?
Sheet

***Here is the sheet assuming someone was buying 2 "library's" (notice current price triples again if you buy 3(indicated by "current price") (E2 WOULD BE $40,000 DOLLARS)
::::EXAMPLE 3::::

Excel Workbook
	A	B	C	D	E
1	PROPERTY	QTY.	BASE PRICE	CURRENT PRICE	TOTAL MONEY SPENT
2	LIBRARY	2	$ 10,000	$ 60,000	WHAT GOES HERE?
Sheet

 

[Peter_SSs]

Is this it?

Excel Workbook
	A	B	C	D	E	F
1	PROPERTY	QTY.	BASE PRICE	CURRENT PRICE	TOTAL MONEY SPENT
2	LIBRARY	2	10,000	60,000	40,000
3
Spend

 

[XxCALLofBOOTYxX]

YESSSS, once again Peter you are a genius...Thank u very much!