if formula to meet several conditions

**a2424** · 03-21-2013, 03:13 AM

hi

i need help with an if formula that if all conditions are met it returns 0 and if only some of them are met then it returns the Cost.

the conditions are as follows :

if the color is Blue, Red or Yellow, and the age is less than 10 and the cost is less than zero then the return value should be 0.

if these conditions are not all met then it should return the Cost (the value in column C)

i have included only a small sample of data the list is much bigger and covers every combination.

thanks so much!

**Fotis1991** · 03-21-2013, 03:18 AM

Try in D4 and copy down.

=IF(OR(AND(A4={"blue","red","yellow"}),AND(B4<10)),0,C4)

**a2424** · 03-21-2013, 03:22 AM

thanks so much!, thats helped me out a lot

**Fotis1991** · 03-21-2013, 03:27 AM

.....................

**a2424** · 03-21-2013, 06:24 PM

im having problems with the following sopreadsheet, ive used the formula you sent through but it doesnt seems to be working with all conditions.

D4 should be returning 0 as the status is Active and the netbalance is less than 0 and the difference in months between Date and DateNOW is less than 6 months? but its returning the value in c4?