Need if Statement
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 |
=IF(AND(G2=0,H2=0),"T",IF(AND(G20,H2=0),"",IF(AND (G2<0,H20),"T",IF(AND(G20,H20),"","other")))) fits your request, you can remove the words 'Blank', 'blank'and 'other' when you have tested the formula. nander Wrote: 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 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=397459 |
=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 |
All times are GMT +1. The time now is 09:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com