=IF(OR(AND(G2=0,H2=0),AND(G2<0,H20)),"T","")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"nander" wrote in
message ...

Column G has header qtys12mo (quanity sold last 12 months)
Column H has header onhand (quanity on hand)

I need an if statement that compares the values in these two columns
and returns the value T or Blank


If qtys12mo and onhand = 0 then T
if qtys12mo 0 and onhand = 0 then Blank
if qtys12mo<0 and onhand 0 then T
if qtys12mo0 and onhand0 then blank


--
nander
------------------------------------------------------------------------
nander's Profile:
http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=397459