Hi Peo
Sorry about the bad post, 1st time I've posted anything, should have thought
it through before sending.
details see previous reply to PCLICVE, when I change my 2 variables, for
the 1st 2 quantities the correct answer is return after that increasing the
quantites does not increase the discount.
It seems that this part of the formula is being acted on
i.e."=IF(AND(C40.25,B510),I15,0)" then the calculation stops.
Thanks all for the time you've spent on this,
Phil


"Peo Sjoblom" wrote:

That is not a good reply, how can anyone help you when all you say is that
it's not working.
Surely you can't expect people to be mind readers? What did not work, did
you get an error, was the result unexpected or did your computer blow up?


--
Regards,

Peo Sjoblom


"Indigo" wrote in message
...
Thanks for getting back so quickly, I've filled the formula as below to
test
and it's not working, any suggestion please.
=IF(AND(C40.25,B510),5,IF(AND(C40.25,B549),7.5 ,IF(AND(C41,B510),10,IF(AND(C41,B549),15,IF(B5 499,20,0)))))

"Bob Phillips" wrote:

=IF(AND(A40.25,B410),Z,IF(AND(A40.25,B449),Y,I F(AND(A41,B410),X,IF(AND(A41,B449),W,IF(B4499 ,V,"Invalid")))))


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Indigo" wrote in message
...
Hi Not too good at maths, trying to produce a formula to calulate
discounts.
if a0.25 and b10 discount =Z
if a0.25 and b49 discount =Y
if a1 and b10 discount =X
if a1 and b49 discount =W
if b499 Discount =V
I Have "=IF(AND(C40.25,B510),I15,0)" for 1st line but can't seem to
add
other lines to the formula is it possible to have 1 formula that
carries
out
all the calulations?