+ Reply to Thread
Results 1 to 3 of 3

Using multiple arguments in a formula

  1. #1
    Registered User
    Join Date
    02-13-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Using multiple arguments in a formula

    I'm trying to create a formula where if the resultant value of a cell return a value as follows

    if 4=4
    if <4 but greater than or equal to 3.5 = 3.5
    if <3.5 but greater than or equal to 3 = 3
    if <3 but greater than or equal to 2 = 2
    if <2 =1

    thanks

  2. #2
    Forum Expert
    Join Date
    07-16-2010
    Location
    Northumberland, UK
    MS-Off Ver
    Excel 2007 (home), Excel 2010 (work)
    Posts
    3,054

    Re: Using multiple arguments in a formula

    There are numerous ways to do this, but the shortest is probably:

    =INDEX({1,2,3,3.5,4},MATCH(A1,{0,2,3,3.5,4},1))

    Assuming your resultant value is in A1.

    Probably the most obvious way, again with the value in A1 is:

    =IF(A1<2,1,IF(A1<3,2,IF(A1<3.5,3,IF(A1<4,3.5,4))))

  3. #3
    Forum Expert Moo the Dog's Avatar
    Join Date
    09-28-2012
    Location
    Wisconsin
    MS-Off Ver
    Office 365 (PC & Mac)
    Posts
    1,845

    Re: Using multiple arguments in a formula

    or...

    =LOOKUP(A1,{0,2,3,3.5,4},{1,2,3,3.5,4})

    Assuming value to lookup is in A1

    - Moo

+ 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