Re: Which formula to use

> May I ask why the 40 at the start of the formula

> Thank you macropod
> May I ask why the 40 at the start of the formula
>
> "macropod" wrote:
>

> > Hi Peter,
> >
> > Assuming unit prices vary in multiples of 5 units, then the formula for
> > calculating the unit price for n units in cell A1 is:
> > =(40+INT(A1/5)*5*6)/A1
> > and, if this formula is in B1, then the total price is:
> > =A1*B1
> > With these formulae, you don't need a list but, if you want to create

> > anyway, put:
> > =ROW()*5
> > in A1, then copy all three formulae down as far as you need.
> >
> > Cheers
> >
> > --
> > macropod
> > [MVP - Microsoft Word]
> >
> >
> > "peterm" <peterm@discussions.microsoft.com> wrote in message
> > news:B08BB91A-9E82-4306-8D3D-DD40FAB8EE25@microsoft.com...

> > > Hi All
> > > I wish to do a spread sheet for pricing and I am not sure what formula

> > use.

> > > I sell 50 items for $340.00 - $6.80 a unit - 55 items for $370.00 -

> > a

> > > unit
> > > 80 items for $520.00 $6.50 a unit. Is there a formula that I can use

> > I

> > > have
> > > a list in column A going from 5 - 100 in steps of 5 (5,10,15 etc) that

> > will

> > > give me the total price in column B and a unit price in Column C.
> > > I know the price for 50 and 55 is correct I guessed the price for 80.

> > > is why I need a list.
> > > Cheers
> > > Peterm

> >
> >
> >