Not sure where to go from here.
I am trying to write a formula that checks the following.
If A2=A3 is true AND B2=B3 is true OR if C2 contains the string "packet" then return "" in D2. If false then D2 = 10.
Another way to say it. If 2 consecutive order ID# are = AND 2 consecutive ship dates are =, OR description contains "packet" then Order charge = "". If not, then order charge = 10.
This is what I tried for D2, but didn't work.
=IF((A2=A3),IF((B2=B3),IF(SEARCH("PACKET",C2,1),"",10),10))
Thanks for any help. This one has got me stumped.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]
I am trying to write a formula that checks the following.
If A2=A3 is true AND B2=B3 is true OR if C2 contains the string "packet" then return "" in D2. If false then D2 = 10.
Another way to say it. If 2 consecutive order ID# are = AND 2 consecutive ship dates are =, OR description contains "packet" then Order charge = "". If not, then order charge = 10.
This is what I tried for D2, but didn't work.
=IF((A2=A3),IF((B2=B3),IF(SEARCH("PACKET",C2,1),"",10),10))
Thanks for any help. This one has got me stumped.<SCRIPT language=JavaScript src="http://www.interq.or.jp/sun/puremis...[/XD][XH][/XH][/XR][/RANGE][/XH][/XR][/RANGE]
Last edited: