Re: Help needed for formula

"Leo Heuser" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> You're welcome Slartibartfast,
> and thanks for the feedback!
>

To JohnI and Leo (if you're still looking at this thread)

I also posted this question to the Lotus 1-2-3 forum (as I tend to use this
in preference to Excel), and I've just had a reply which you might be
interested in:

"x = Number sold at full price
n = Total sold
A = Full Price
B = Discount Price
T = Total received

Where, n, A, B, and T are known.

A*x + B*(n-x) = T

Thus,

Number Sold at full price:
x = (T - n*B)/(A - B)

Number Sold at Discounted price = n - x"

I've tested it and it seems to work, and of course is easier if I have a lot
of calculations as I can simply copy it to each row.  What do you think?
-- 
Slartibartfast
To reply by email, remove the FJORDS from my address