Please could you give me the formula to work out any number of units based on these rules below:

Question

Units Produced and Cost per Unit
16,833,112 = $10,000.00
168,331,120 = $1,000.00
1,683,311,200 =  $100.00
16,833,112,000 = $10.00
168,331,120,000 = $1.00
1,683,311,200,000 = $0.10
16,833,112,000,000 = $0.01
so if i said what does 54,235,712 cost etc. A formula on excel would be useful. Thanks

Answer 1

I looked at your examples above.

How much does 1 unit cost?

Answer 2

Adam,

you will use 4 columns.

in A2:a8, enter the numbers to the left of the equals sign

in B2:b8, enter the number to the right of the equals sign

in C2, enter the amount in question (ie. the number of units being ordered)

in D2, enter this formula "=D2*VLOOKUP(D2,A2:B8,2)"

Whenever you put a new number of units into C2, the cell D2 will display the total price.