Re: Help needed for formula

"Glenn P." <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Slartibartfast wrote:
>
> > Can anyone help with this example:
> >
> > In my shop, I started a Sale halfway through the month.
> >
> > On one item I sell, I reduced the price from £3 to £2.  I took a total
of
> > £100 in sales for this item.
> >
> > Is there a formula which  will tell me how many I sold at £3 and how
many I
> > sold at £2?
> >
> > TIA
> >
>
>
> You haven't given enough information here to make that calculation using
> *any* method.
>
Many apologies - what I *should* have added is that I also know the total
number of items sold - in my example it's 40.  (Obviously in the example the
answer would be 20 @ £3 and 20 @ £2 - I just need t know if there a way of
calculating this automatically)
-- 
Slartibartfast
To reply by email, remove the FJORDS from my address