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!
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!
Try:
=IF(AND(M2>=38000,M2<=39000), "p2", "")
If you don't want p2 in response to M2 being actually 38000 or 39000 then
miss out the "=" in both tests.
--
HTH
Sandy
[email protected]
Replace@mailinator with @tiscali.co.uk
"piglett51" <[email protected]> wrote
in message news:[email protected]...
>
> 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
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks