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?