combining IF formulas

it seems I have few more scenarios than I thought.. Is there a way to put a formula with below reasononing?

1) if Q1=0 AND Q2=0 and Cost ABS> 1,000 then comment: "W"
2) if Q1=0 AND Q2=0 and Cost ABS< 1,000 then comment: "X"
3) if Q1<>0 and = Q2<>0 irrelevant of the Cost then comment: "Y"
4) if Q1<>Q2 irrelevant of the Cost then comment: "Z"

not sure if below is well readable so uploading example

Please Login or Register  to view this content.

Hi all, I am having trouble combing below formulas..Would anyone be able to help out with below. Thanks so much

=IF(AND(E12=0,ABS(G12)<1000),"to order","")



=IF(AND(E12=F12),"OK","")

The two TRUE conditions, one in each formula, aren't mutually exclusive so you need to decide which takes precedence, assuming the first one does then try

=IF(AND(E12=0,ABS(G12)<1000),"to order",IF(E12=F12,"OK",""))