+ Reply to Thread
Results 1 to 2 of 2

Another IF question

  1. #1
    Registered User
    Join Date
    09-15-2005
    Posts
    3

    Another IF question

    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!

  2. #2
    Sandy Mann
    Guest

    Re: Another IF question

    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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1