+ Reply to Thread
Results 1 to 4 of 4

IF Function Help for Three Arguments

  1. #1
    Registered User
    Join Date
    04-01-2017
    Location
    California
    MS-Off Ver
    2016
    Posts
    10

    IF Function Help for Three Arguments

    I want to create an IF function that will show "Serviceable", "Expiring Soon", or "Expired"

    The function I tried to enter is = IF ( A2 > = TODAY()+30, "Serviceable", "Expiring Soon")

    This function works without issue. But if I try to enter the second IF function like

    = IF ( A2 > = TODAY ( ) + 30, "Serviceable", "Expiring Soon", IF (A2 < TODAY() ,"EXPIRED")

    I get the error that says I'm missing a parenthesis or I have too many arguments.

    Can anyone see where I'm going wrong?

  2. #2
    Forum Contributor
    Join Date
    08-04-2004
    Location
    Amsterdam
    MS-Off Ver
    2016
    Posts
    186

    Re: IF Function Help for Three Arguments

    Try this. The problem with your formula was the order. Your second IF was ignored and formula was expecting a closing bracket after "expiring soon" as that was the FALSE part.

    = IF ( A2 > = TODAY ( ) + 30, "Serviceable", IF (A2 < TODAY() ,"EXPIRED","Expiring Soon"))

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,208

    Re: IF Function Help for Three Arguments

    Try

    =IF(A2 < TODAY(),"Expired",IF(A2 > TODAY()+30,"Serviceable","Expiring Soon"))

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: IF Function Help for Three Arguments

    Just for variety,

    =LOOKUP(A2, {-99000,0,31} + TODAY(), {"Expired","Expiring Soon","Serviceable"})
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Too many arguments for this function
    By JmundleBofA in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-20-2014, 01:01 PM
  2. [SOLVED] IF function with more than 2 arguments.
    By SeanMck in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-21-2013, 08:37 AM
  3. [SOLVED] Too Many Arguments for This Function.
    By sander07 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-22-2013, 07:34 PM
  4. Too Many Arguments for this Function
    By nohmis in forum Excel General
    Replies: 3
    Last Post: 03-08-2012, 05:34 PM
  5. Too many arguments for this function
    By jhp580 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-19-2009, 09:41 PM
  6. sum :Too many arguments for this function
    By eparsons in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-04-2007, 01:05 PM
  7. Replies: 0
    Last Post: 06-20-2006, 10:55 AM
  8. Replies: 1
    Last Post: 12-20-2005, 11:10 PM

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