combining IF formulas

[donyc]

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

ID	Q1	Q2	Cost	Comments	
1234	0 	0 	8,000 	W	example 1
9595	0 	0 	200 	X	example 2
5422	100 	100 	7,000 	Y	example 3
6944	100 	0 	200 	Z	example 4
2412	100 	0 	5,000 	Z	example 4
4212	0 	100 	200 	Z	example 4
1565	0 	100 	5,000 	Z	example 4

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","")

[daddylonglegs]

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",""))

[donyc]

thanks so much