+ Reply to Thread
Results 1 to 3 of 3

3 arguments in if statements

  1. #1
    Registered User
    Join Date
    09-17-2011
    Location
    Alberta
    MS-Off Ver
    Excel 2010
    Posts
    63

    3 arguments in if statements

    Hi

    What formula do you use In cell c3 if want the answer to be

    o < 12 "MONTHLY"
    o Between 12-24 "BI-MONTHLY"
    o >24 "YEARLY"

    based on data in cell C2

    I attached spreadsheet

    If anyone can help I appreciate it!

    Thanks For your help

    Jeff
    Attached Files Attached Files
    Last edited by Jr66; 11-02-2021 at 06:22 PM.

  2. #2
    Forum Expert WideBoyDixon's Avatar
    Join Date
    10-03-2016
    Location
    Sheffield, UK
    MS-Off Ver
    365
    Posts
    2,182

    Re: 3 arguments in if statements

    I can only assume you mean the number in B3. C3 is then this:

    Please Login or Register  to view this content.
    WBD
    Office 365 on Windows 11, looking for rep!

  3. #3
    Registered User
    Join Date
    09-17-2011
    Location
    Alberta
    MS-Off Ver
    Excel 2010
    Posts
    63

    Re: 3 arguments in if statements

    Thank You works great!

+ 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] Nested IF AND Statements - too many arguments
    By alexad1498 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-30-2019, 06:42 PM
  2. Replies: 3
    Last Post: 11-09-2016, 01:42 PM
  3. [SOLVED] If and statements with 3 arguments
    By trosasco23 in forum Excel General
    Replies: 4
    Last Post: 04-27-2016, 08:44 AM
  4. Multiple IF/IFERROR statements, resulting in "too many arguments" error
    By agraham in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-22-2016, 09:27 AM
  5. [SOLVED] IF AND statements with other arguments
    By trosasco23 in forum Excel General
    Replies: 4
    Last Post: 10-16-2014, 03:40 PM
  6. Replies: 3
    Last Post: 09-07-2009, 04:48 PM
  7. IF Statements w/ more than 7 arguments needed
    By Jamers8 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-07-2005, 11:03 AM

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