ScoobyWon't

I'm trying, without any success, to work out an equation and then how to input it into a spreadsheet to show purchase costs.

I know the following:

Fixed fee = £28.
Price per Kilo = £2.

30kg creates 100 units.

How do I create a formula in a spreadsheet which will show the purchase costs based on the number units created including the fixed fee, ranging from 0 to 300?

e.g. 30*£2 = £60
£60 + £28 = £88
£88/100 = £0.88

60*£2= £120
£120 + £28 = £148
£148/200 = £0.74

boxst

What out of the above are you looking to enter, and what to calculate?

DJ_Jon

iTrader: (7)

sum(((A1*2)+28)/100)

sum(((A1*2)+28)/200)

A1 is the cell that the variable is contained in.

DJ_Jon

iTrader: (7)

do you mean there are price bandings - 0 to 100 100 to 200 & 200 to 300?

ScoobyWon't

I'd like to be able to put in any quantity of units required and have the cost displayed.

warrtster

iTrader: (5)

PM me your email address and I'll send you something in Excel

speedking

The formula is total cost =numunits/100*60+28 which simplifies to unitcost =0.6+28/numunits

So in excel put numunits in cell A1.
In cell A2 type =.6+28/A1

Then whatever value you type in A1 will give the unit cost in A2.
Just drag down if you want a range of values.

CREWJ

Just in case any of the above is confusing you. Here is a pic;

speedking

Except that your formula is wrong :

CREWJ

I just used the formula the OP used.