Results 1 to 5 of 5

Thread: IF Formula - multiple values

  1. #1

    Talking IF Formula - multiple values



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone!

    I'm trying to come up with a formula that allows me to come up with a certain value (number) if the value next to it (text) is typed in.

    e.g: IF D4 is equal to "Complete", then return "1". IF D4 is equal to "In process", return "0". IF D4 is equal to "Pending", return "-1"

    Thanks in advance,

  2. #2
    Acolyte Weazel's Avatar
    Join Date
    Jul 2014
    Location
    Florida
    Posts
    26
    Articles
    0
    Excel Version
    2016
    maybe something like....

    =LOOKUP(D4,{"Complete","In Process","Pending"},{1,0,-1})

  3. #3
    Conjurer sambit's Avatar
    Join Date
    Sep 2014
    Posts
    143
    Articles
    0
    Excel Version
    Excel2007
    Try below formula
    =IF(D4="COMPLETE",1,IF(D4="IN PROCESS",0,IF(D4="PENDING",-1,"")))

  4. #4
    Thank you all, it worked!

  5. #5
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,721
    Articles
    0
    Excel Version
    2010 on Xubuntu

Posting Permissions

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