+ Reply to Thread
Results 1 to 4 of 4

Hi all, how can I use multiple arguments in the IF formula?

  1. #1
    Registered User
    Join Date
    06-17-2021
    Location
    Zele
    MS-Off Ver
    2010
    Posts
    2

    Question Hi all, how can I use multiple arguments in the IF formula?

    So I have this spreadsheet with responses from a Google form.
    I want column I to be filled in only when it is a different input than the standard countries they get to choose from.
    How can I do this?

    thank you in advance!
    Last edited by Yazmin9240; 06-17-2021 at 09:41 AM.

  2. #2
    Registered User
    Join Date
    06-15-2021
    Location
    USA
    MS-Off Ver
    Office 365
    Posts
    34

    Re: Hi all, how can I use multiple arguments in the IF formula?

    =IFERROR(IFS(A2="The Netherlands","",A2="Belgium"," ",A2="Germany","",A2="Great Britain","",A2="Poland","",A2="Switzerland","",A2="Austria",""),A2)

    Could also do IFSNOT but this is easy enough to have the error copy it.

    I believe this is what you are asking but the spreadsheet and information you provided was very confusing.
    Last edited by Zaerick; 06-17-2021 at 09:50 AM.

  3. #3
    Valued Forum Contributor
    Join Date
    05-15-2017
    Location
    US
    MS-Off Ver
    365
    Posts
    901

    Re: Hi all, how can I use multiple arguments in the IF formula?

    Using =IFS may be what you need, allows for multiple criteria.
    But your file is not very clear what you expect.

    Can you Provide expected result sample in the file?
    If you find the suggestion or solution helpful, please consider adding reputation to the post.

  4. #4
    Registered User
    Join Date
    06-17-2021
    Location
    Zele
    MS-Off Ver
    2010
    Posts
    2

    Re: Hi all, how can I use multiple arguments in the IF formula?

    Thanks a lot!
    It worked!

+ 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] count multiple arguments in one cell across multiple months
    By angelspeace in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 03-12-2020, 06:22 PM
  2. Replies: 17
    Last Post: 07-31-2019, 12:30 AM
  3. [SOLVED] Adding multiple arguments to an IF(And formula
    By GSmith8 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2014, 06:21 AM
  4. Using multiple arguments in a formula
    By msr1015 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-13-2013, 05:27 PM
  5. Replies: 3
    Last Post: 08-29-2011, 12:42 AM
  6. SUM formula arguments using data from multiple cells
    By dwtaxguy in forum Excel General
    Replies: 1
    Last Post: 02-15-2010, 02:07 PM

Tags for this Thread

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