Hi Filled in details to test formula as below and it's not working any
suggestion please?
=IF(C40.25,IF(B510,5,IF(B549,7.5,0)),IF(C41,IF (B510,10,IF(B449,15,0)),IF(C4499,20,0)))
not sure what a VLOOKUP is will search help
Phil

"PCLIVE" wrote:

If you wanted to go the route of a nested IF statement, then this may work
for you.

=IF(C40.25,IF(B510,I15,IF(B549,"DiscountYCell", 0)),IF(C41,IF(B510,"DiscountXCell",IF(B449,"Dis countWCell",0)),IF(C4499,"DiscountVCell",0)))

However, you may want to consider creating a table and using VLOOKUP.

HTH,
Paul

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