+ Reply to Thread
Results 1 to 8 of 8

Error message on 4 IF formulas in one function

  1. 01-10-2012, 11:30 PM #1
    blondie1986
    blondie1986 is offline
    Registered User
    Join Date
    01-10-2012
    Location
    europe
    MS-Off Ver
    Excel 2003
    Posts
    22

    Error message on 4 IF formulas in one function

    Hi,

    can somebody help me with this formular. i do not find the mistake.

    =IF((V39)="S.,IF((AD39)<9,45000*(AD39) - 90000,IF(AD29)>75,9034393+0*(AD29),0.00005*(AD29)^6-0.0262*(AD29)^5+5.4402*(AD29)^4-535.46*(AD29)^3+23696*(AD29)^2-244225*(AD29)+987881)),IF((V39)=""M",IF(AD39)<16,36464*LN(AD39)+14453,IF(58<(AD39),0*(AD39)+1401447,7*(-10)^-6*(AD39)^6-0.0037*(AD39)^5+0.772*(AD39)^4-77.836*(AD39)^3+3547.4*(AD39)^2-37096*(AD39)+114656),IF((AD39)>33,0*(AD39)+328286,0.000003*(AD39)^6 - 0.0014*(AD39)^5 + 0.211*(AD39)^4 - 12.86*(AD39)^3 + 131.04*(AD39)^2 + 14689*(AD39) - 45019))

    i looked at the gaps. they are all alright. also the " " but still there is a mistake . please help. thanks
    Reply With QuoteRegister To Reply
  2. 01-11-2012, 01:37 AM #2
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Error message on 4 IF formulas in one function

    RIGHT at the start, is that period supposed to be a quote?

    =IF((V39)="S",IF((AD39)....
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)
    Reply With QuoteRegister To Reply
  3. 01-11-2012, 01:53 AM #3
    blondie1986
    blondie1986 is offline
    Registered User
    Join Date
    01-10-2012
    Location
    europe
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Error message on 4 IF formulas in one function

    =IF((V30)="S.,IF((AD29)<9,45000*(AD29) -90000,IF(A2>75,9034393+0*(AD29),0.00005*(AD29)^6-0.0262*(AD29)^5+5.4402*(AD29)^4-535.46*(AD29)^3+23696*(AD29)^2-244225*(AD29)+987881)),IF((V30)=""M",IF(AD29<16,36464*LN(AD29)+14453,IF(58<AD29,0*(AD29)+1401447,7*(-10)^-6*(AD29)^6-0.0037*(AD29)^5+0.772*(AD29)^4-77.836*(AD29)^3+3547.4*(AD29)^2-37096*(AD29)+114656),IF((AD29)>33,0*(AD29)+328286,0.000003*(AD29)^6 - 0.0014*(AD29)^5 + 0.211*(AD29)^4 - 12.86*(AD29)^3 + 131.04*(AD29)^2 + 14689*(AD29) - 45019))


    hi yes it s suppossed to be that (the "S. )way. well it s not the mistake. now all excel says is that i entered to many arguments...i am going nuts here
    Reply With QuoteRegister To Reply
  4. 01-11-2012, 02:01 AM #4
    blondie1986
    blondie1986 is offline
    Registered User
    Join Date
    01-10-2012
    Location
    europe
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Error message on 4 IF formulas in one function

    well yeah i "fixed" it to this

    =IF((V30)="S",IF((AD29)<9,45000*(AD29) -90000,IF(A2>75,9034393+0*(AD29),0.00005*(AD29)^6-0.0262*(AD29)^5+5.4402*(AD29)^4-535.46*(AD29)^3+23696*(AD29)^2-244225*(AD29)+987881)),IF((V30)="M",IF(AD29<16,36464*LN(AD29)+14453,IF(58<AD29,0*(AD29)+1401447,7*(-10)^-6*(AD29)^6-0.0037*(AD29)^5+0.772*(AD29)^4-77.836*(AD29)^3+3547.4*(AD29)^2-37096*(AD29)+114656),IF((AD29)>33,0*(AD29)+328286,0.000003*(AD29)^6 - 0.0014*(AD29)^5 + 0.211*(AD29)^4 - 12.86*(AD29)^3 + 131.04*(AD29)^2 + 14689*(AD29) - 45019))

    but still it says too many arguments. please help. thanks.
    Reply With QuoteRegister To Reply
  5. 01-11-2012, 03:21 AM #5
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Error message on 4 IF formulas in one function

    Hi

    We don't have a sample workbook, to test the formula..

    But if it is so..,then "split" the formula in 2(helper & hide) cells and then use Concatenate function, for these two cells.

    Hope to helps you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  6. 01-11-2012, 04:21 AM #6
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Error message on 4 IF formulas in one function

    With only 7 IF commands allowed to operate in an Excel 2003 formula, you will need to switch methods.

    In a sample workbook, create a table that shows in one column the start of the "range" for the evaluation, and in the next column the formula you would want run on values in that range. Post that up and we can help switch you to some sort of LOOKUP() and/or CHOOSE() combination.
    Reply With QuoteRegister To Reply
  7. 01-17-2012, 01:26 AM #7
    blondie1986
    blondie1986 is offline
    Registered User
    Join Date
    01-10-2012
    Location
    europe
    MS-Off Ver
    Excel 2003
    Posts
    22

    Re: Error message on 4 IF formulas in one function

    thanks for helping it worked!
    Reply With QuoteRegister To Reply
  8. 01-17-2012, 05:34 AM #8
    JBeaucaire
    JBeaucaire is offline
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Error message on 4 IF formulas in one function

    If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1