Hi Paul
Yes your right, sorry there were so many post coming in I just missed yours.
I've tested it & it works & is shorter, thanks for all your help.
All the best
Phil

"PCLIVE" wrote:

I think my formula in the abve post was shorter...but they seem to
accomplish the same result.


"Indigo" wrote in message
...
Thanks Dana
That works really well, easy when you know how.

all the best
Phil

"Dana DeLouis" wrote:

I Have "=IF(AND(C40.25,B510),I15,0)"

Hi. I believe the logic is a little off.
If values pass the first test, it is possible they pass all the other
tests.
For example, if C4 =2, and B5=600, then this meets every test, especially
the first test, and not the last test as probably expected.
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...

Usually, one works from highest to lowest.

=IF(B1499,20,IF(AND(A11,B149),15,IF(AND(A11,B1 10),10,IF(AND(A10.25,B149),7.5,IF(AND(A10.25,B 110),5,0)))))

--
HTH :)
Dana DeLouis


"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?