This is probably really easy and I am just blanking on it. Looking for
help?

IF(M2="38000:39000", "p2", "")

So I am trying to populate a field only IF M2 is between 38000-39000.

Thanks!


--
piglett51
------------------------------------------------------------------------
piglett51's Profile: http://www.excelforum.com/member.php...o&userid=27291
View this thread: http://www.excelforum.com/showthread...hreadid=468034