Results 1 to 2 of 2

Thread: IF function using multible numbers

  1. #1

    Question IF function using multible numbers



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

    Hi!

    I want to try to use the IF function to make a car option with both positive and negative attributes out of 12 ratings a participant gives about these 12 attributes. For the car i want the following ratings to be positive: 1,3,4,6,7,8,10,12, whereas the others inbetween are supposed to be negative (2,5,9,11) . I made the following formula, but it does not seem to do what i want:

    =IF(A2=1+AND(3,4,6,7,8,10,12),"Has good mileage","has poor mileage")

    There is something wrong in the formula i just don't know what it is. the OR function also does not seem to work. Does anyone have a clue how i can make these ratings the positive ones while the other onesare negtive?

    I really apreciate the help

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,437
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =IF(OR(A2={1,3,4,6,7,8,10,12}),"Has good mileage","has poor mileage")


Posting Permissions

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