+ Reply to Thread
Results 1 to 4 of 4

IF function with 4 variables

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    UK
    MS-Off Ver
    Office for Mac: 16.69.1
    Posts
    5

    IF function with 4 variables

    Hi, could someone help me to get this function to work, it worked with 3 (see first line), but when I try with 4 it tells me I've added too many variables.

    *I have removed some text from the return values*

    3

    =IF(AN11="";"";IF(AND(AN11=0;AN11>=0);"Unfortunately";"I am excited to announce that"&" "&AN11&" "& "€" &" "&"will be deducted from."))

    4

    =IF(AN11="";"";IF(AND(AN11=0;AN11>=0);"Unfortunately";"I am excited to announce that"&" "&AN11&" "&"€"&" "&"will be deducted from."));IF(AND(AN11="FULL");"I am excited to inform you that full, only will be charged.")

    Thank you

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: IF function with 4 variables

    Something like this maybe
    Please Login or Register  to view this content.
    in your formula, the second IF has both conditions set, therefore it won't accept another nested IF.

  3. #3
    Registered User
    Join Date
    06-13-2018
    Location
    UK
    MS-Off Ver
    Office for Mac: 16.69.1
    Posts
    5

    Re: IF function with 4 variables

    It didn't work when I put that in in full, but did when I put it in as follows:

    =IF(AN11="","",IF(AN11="FULL","I am excited to inform you that full, only will be charged.",(IF(AND(AN11=0,AN11>=0),"Unfortunately","I am excited to announce that"&" "&AN11&" "&"€"&" "&"will be deducted from."))

    Thanks for the help!

  4. #4
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    Office 365
    Posts
    2,108

    Re: IF function with 4 variables

    That's great. Please mark the thread as Solved from Thread Tools, right corner, your first post. Thanks.

+ 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. if function 3 variables
    By Woddow in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-26-2015, 09:59 PM
  2. New function for more variables
    By Alenn in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-10-2014, 12:38 PM
  3. Using IF function for two different variables
    By doshitushar in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-17-2013, 03:02 AM
  4. Replies: 3
    Last Post: 09-11-2012, 02:03 AM
  5. IF Function with 2 variables
    By este994 in forum Excel General
    Replies: 2
    Last Post: 05-09-2011, 07:14 AM
  6. 2 variables in a function
    By unclesnoop in forum Excel General
    Replies: 3
    Last Post: 01-28-2011, 10:58 AM
  7. IF function along with variables
    By vs4hire in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-12-2007, 09:43 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