+ Reply to Thread
Results 1 to 10 of 10

Need help with a formula

  1. #1
    Phxlatinoboi®
    Guest

    Need help with a formula

    My formual should look like this:

    =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))

    but I keep getting an error message saying too many arguments. How can I
    overcome this? Please advise.

  2. #2
    Elkar
    Guest

    RE: Need help with a formula

    You do have too many arguments. What your formula is saying:

    IF: I9 >=0
    THEN: (G9-F9)/F9
    ELSE: (H9-G9)/G9
    ?: (I9-H9)/H9

    The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    accomplish we could help you write the formula.

    Elkar

    "Phxlatinoboi®" wrote:

    > My formual should look like this:
    >
    > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    >
    > but I keep getting an error message saying too many arguments. How can I
    > overcome this? Please advise.


  3. #3
    AAMIFC
    Guest

    RE: Need help with a formula

    If I am not mistaken you have the Logical_Test and 3 possible results. IF
    statements have a True or False output.

    "Phxlatinoboi®" wrote:

    > My formual should look like this:
    >
    > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    >
    > but I keep getting an error message saying too many arguments. How can I
    > overcome this? Please advise.


  4. #4
    Phxlatinoboi®
    Guest

    RE: Need help with a formula

    What I need to do is:

    Compare Column B to A and get the difference in %. Then I will compare C to
    B and get the different in % and then the same on Column D to C.

    Hope this makes sense.

    Phxlatinoboi®

    "Elkar" wrote:

    > You do have too many arguments. What your formula is saying:
    >
    > IF: I9 >=0
    > THEN: (G9-F9)/F9
    > ELSE: (H9-G9)/G9
    > ?: (I9-H9)/H9
    >
    > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    > accomplish we could help you write the formula.
    >
    > Elkar
    >
    > "Phxlatinoboi®" wrote:
    >
    > > My formual should look like this:
    > >
    > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    > >
    > > but I keep getting an error message saying too many arguments. How can I
    > > overcome this? Please advise.


  5. #5
    Elkar
    Guest

    RE: Need help with a formula

    Ok, I'm still unclear what you're trying to do here. I don't see where an IF
    Statement comes into play at all. Also, I'm not sure how your Columns A-D
    relate to Columns F-I in your formula.

    That said, to get the percent differences, I think you can use these formulas:

    Difference from B to A: =(B9/A9)-1
    Difference from C to B: =(C9/B9)-1
    Difference from D to C: =(D9/C9)-1

    HTH,
    Elkar

    "Phxlatinoboi®" wrote:

    > What I need to do is:
    >
    > Compare Column B to A and get the difference in %. Then I will compare C to
    > B and get the different in % and then the same on Column D to C.
    >
    > Hope this makes sense.
    >
    > Phxlatinoboi®
    >
    > "Elkar" wrote:
    >
    > > You do have too many arguments. What your formula is saying:
    > >
    > > IF: I9 >=0
    > > THEN: (G9-F9)/F9
    > > ELSE: (H9-G9)/G9
    > > ?: (I9-H9)/H9
    > >
    > > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    > > accomplish we could help you write the formula.
    > >
    > > Elkar
    > >
    > > "Phxlatinoboi®" wrote:
    > >
    > > > My formual should look like this:
    > > >
    > > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    > > >
    > > > but I keep getting an error message saying too many arguments. How can I
    > > > overcome this? Please advise.


  6. #6
    Phxlatinoboi®
    Guest

    RE: Need help with a formula

    Elkar,

    I have 5 cells i use. F9, G9, H9. I9 & S9. The values of cells are taken
    from another worksheet. What I am trying to do is this.

    if there is value in G9 minus that from F9 and divide by F9 to give me the %
    in S9. Now if there is value in H9 then I will minus that from G9 and divide
    it by G9 to get the % in S9. Now if there is value in I9 that will be minued
    from H9 and then divided by the value in H9 to get % for S9.

    The formula I want is in S9.

    Hope this makes sense.. Also, someone here mentioned I could nest and get
    the formula to work. What is nesting?

    The formual again that I want to use is:

    -if(I9<=0,(G9-F9)/F9,(H9-G9)/G9),(I9-H9)/H9)

    "Elkar" wrote:

    > Ok, I'm still unclear what you're trying to do here. I don't see where an IF
    > Statement comes into play at all. Also, I'm not sure how your Columns A-D
    > relate to Columns F-I in your formula.
    >
    > That said, to get the percent differences, I think you can use these formulas:
    >
    > Difference from B to A: =(B9/A9)-1
    > Difference from C to B: =(C9/B9)-1
    > Difference from D to C: =(D9/C9)-1
    >
    > HTH,
    > Elkar
    >
    > "Phxlatinoboi®" wrote:
    >
    > > What I need to do is:
    > >
    > > Compare Column B to A and get the difference in %. Then I will compare C to
    > > B and get the different in % and then the same on Column D to C.
    > >
    > > Hope this makes sense.
    > >
    > > Phxlatinoboi®
    > >
    > > "Elkar" wrote:
    > >
    > > > You do have too many arguments. What your formula is saying:
    > > >
    > > > IF: I9 >=0
    > > > THEN: (G9-F9)/F9
    > > > ELSE: (H9-G9)/G9
    > > > ?: (I9-H9)/H9
    > > >
    > > > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    > > > accomplish we could help you write the formula.
    > > >
    > > > Elkar
    > > >
    > > > "Phxlatinoboi®" wrote:
    > > >
    > > > > My formual should look like this:
    > > > >
    > > > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    > > > >
    > > > > but I keep getting an error message saying too many arguments. How can I
    > > > > overcome this? Please advise.


  7. #7
    Sandy Mann
    Guest

    Re: Need help with a formula

    "Phxlatinoboi®" <[email protected]> wrote in message
    news:[email protected]...
    > Elkar,
    >
    > if there is value in G9 minus that from F9 and divide by F9 to give me the
    > %
    > in S9. Now if there is value in H9 then I will minus that from G9 and
    > divide
    > it by G9 to get the % in S9. Now if there is value in I9 that will be
    > minued
    > from H9 and then divided by the value in H9 to get % for S9.
    >

    What you have posted does not make sense, (at least to me).

    > if there is value in G9 minus that from F9 and divide by F9 to give me the
    > %
    > in S9


    If there is a value in G9 then after this calculation the function is
    finished. It will only get past this point if G9 is empty but:

    in S9. Now if there is value in H9 then I will minus that from G9 and
    divide
    > it by G9 to get the % in S9


    How can you Minus H9 from G9 when by definition G9 is empty?

    In the same way the calculation can only get into the last part of your
    explanation if G9 and H9 are both empty so how can you use H9 in the
    calculation?

    --
    HTH

    Sandy
    [email protected]
    [email protected] with @tiscali.co.uk
    "Phxlatinoboi®" <[email protected]> wrote in message
    news:[email protected]...
    > Elkar,
    >
    > I have 5 cells i use. F9, G9, H9. I9 & S9. The values of cells are taken
    > from another worksheet. What I am trying to do is this.
    >
    > if there is value in G9 minus that from F9 and divide by F9 to give me the
    > %
    > in S9. Now if there is value in H9 then I will minus that from G9 and
    > divide
    > it by G9 to get the % in S9. Now if there is value in I9 that will be
    > minued
    > from H9 and then divided by the value in H9 to get % for S9.
    >
    > The formula I want is in S9.
    >
    > Hope this makes sense.. Also, someone here mentioned I could nest and get
    > the formula to work. What is nesting?
    >
    > The formual again that I want to use is:
    >
    > -if(I9<=0,(G9-F9)/F9,(H9-G9)/G9),(I9-H9)/H9)
    >
    > "Elkar" wrote:
    >
    >> Ok, I'm still unclear what you're trying to do here. I don't see where
    >> an IF
    >> Statement comes into play at all. Also, I'm not sure how your Columns
    >> A-D
    >> relate to Columns F-I in your formula.
    >>
    >> That said, to get the percent differences, I think you can use these
    >> formulas:
    >>
    >> Difference from B to A: =(B9/A9)-1
    >> Difference from C to B: =(C9/B9)-1
    >> Difference from D to C: =(D9/C9)-1
    >>
    >> HTH,
    >> Elkar
    >>
    >> "Phxlatinoboi®" wrote:
    >>
    >> > What I need to do is:
    >> >
    >> > Compare Column B to A and get the difference in %. Then I will compare
    >> > C to
    >> > B and get the different in % and then the same on Column D to C.
    >> >
    >> > Hope this makes sense.
    >> >
    >> > Phxlatinoboi®
    >> >
    >> > "Elkar" wrote:
    >> >
    >> > > You do have too many arguments. What your formula is saying:
    >> > >
    >> > > IF: I9 >=0
    >> > > THEN: (G9-F9)/F9
    >> > > ELSE: (H9-G9)/G9
    >> > > ?: (I9-H9)/H9
    >> > >
    >> > > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you
    >> > > wanted to
    >> > > accomplish we could help you write the formula.
    >> > >
    >> > > Elkar
    >> > >
    >> > > "Phxlatinoboi®" wrote:
    >> > >
    >> > > > My formual should look like this:
    >> > > >
    >> > > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    >> > > >
    >> > > > but I keep getting an error message saying too many arguments. How
    >> > > > can I
    >> > > > overcome this? Please advise.




  8. #8
    Elkar
    Guest

    RE: Need help with a formula

    Ok, that makes more sense. Based on your description, I think this is what
    you're looking for:

    =IF(I9<>0,(H9-I9)/I9,IF(H9<>0,(G9-H9)/H9,IF(G9<>0,(F9-G9)/G9,0)))

    A Nested statement is where you plug in a function as criteria within
    another function. So, the above uses Nested IF Statements. So, if the first
    part of the formula resolves to FALSE, then it will consult a second IF
    Statement, and if that results to FALSE, then a third. You can "nest" up to
    7 functions.

    HTH,
    Elkar


    "Phxlatinoboi®" wrote:

    > Elkar,
    >
    > I have 5 cells i use. F9, G9, H9. I9 & S9. The values of cells are taken
    > from another worksheet. What I am trying to do is this.
    >
    > if there is value in G9 minus that from F9 and divide by F9 to give me the %
    > in S9. Now if there is value in H9 then I will minus that from G9 and divide
    > it by G9 to get the % in S9. Now if there is value in I9 that will be minued
    > from H9 and then divided by the value in H9 to get % for S9.
    >
    > The formula I want is in S9.
    >
    > Hope this makes sense.. Also, someone here mentioned I could nest and get
    > the formula to work. What is nesting?
    >
    > The formual again that I want to use is:
    >
    > -if(I9<=0,(G9-F9)/F9,(H9-G9)/G9),(I9-H9)/H9)
    >
    > "Elkar" wrote:
    >
    > > Ok, I'm still unclear what you're trying to do here. I don't see where an IF
    > > Statement comes into play at all. Also, I'm not sure how your Columns A-D
    > > relate to Columns F-I in your formula.
    > >
    > > That said, to get the percent differences, I think you can use these formulas:
    > >
    > > Difference from B to A: =(B9/A9)-1
    > > Difference from C to B: =(C9/B9)-1
    > > Difference from D to C: =(D9/C9)-1
    > >
    > > HTH,
    > > Elkar
    > >
    > > "Phxlatinoboi®" wrote:
    > >
    > > > What I need to do is:
    > > >
    > > > Compare Column B to A and get the difference in %. Then I will compare C to
    > > > B and get the different in % and then the same on Column D to C.
    > > >
    > > > Hope this makes sense.
    > > >
    > > > Phxlatinoboi®
    > > >
    > > > "Elkar" wrote:
    > > >
    > > > > You do have too many arguments. What your formula is saying:
    > > > >
    > > > > IF: I9 >=0
    > > > > THEN: (G9-F9)/F9
    > > > > ELSE: (H9-G9)/G9
    > > > > ?: (I9-H9)/H9
    > > > >
    > > > > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    > > > > accomplish we could help you write the formula.
    > > > >
    > > > > Elkar
    > > > >
    > > > > "Phxlatinoboi®" wrote:
    > > > >
    > > > > > My formual should look like this:
    > > > > >
    > > > > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    > > > > >
    > > > > > but I keep getting an error message saying too many arguments. How can I
    > > > > > overcome this? Please advise.


  9. #9
    Phxlatinoboi®
    Guest

    RE: Need help with a formula

    AWESOME!!! Now the only thing left is that when I get my results in S9 it no
    longer changes color (ie red - negative, black positive)

    What can I do for that?

    "Elkar" wrote:

    > Ok, that makes more sense. Based on your description, I think this is what
    > you're looking for:
    >
    > =IF(I9<>0,(H9-I9)/I9,IF(H9<>0,(G9-H9)/H9,IF(G9<>0,(F9-G9)/G9,0)))
    >
    > A Nested statement is where you plug in a function as criteria within
    > another function. So, the above uses Nested IF Statements. So, if the first
    > part of the formula resolves to FALSE, then it will consult a second IF
    > Statement, and if that results to FALSE, then a third. You can "nest" up to
    > 7 functions.
    >
    > HTH,
    > Elkar
    >
    >
    > "Phxlatinoboi®" wrote:
    >
    > > Elkar,
    > >
    > > I have 5 cells i use. F9, G9, H9. I9 & S9. The values of cells are taken
    > > from another worksheet. What I am trying to do is this.
    > >
    > > if there is value in G9 minus that from F9 and divide by F9 to give me the %
    > > in S9. Now if there is value in H9 then I will minus that from G9 and divide
    > > it by G9 to get the % in S9. Now if there is value in I9 that will be minued
    > > from H9 and then divided by the value in H9 to get % for S9.
    > >
    > > The formula I want is in S9.
    > >
    > > Hope this makes sense.. Also, someone here mentioned I could nest and get
    > > the formula to work. What is nesting?
    > >
    > > The formual again that I want to use is:
    > >
    > > -if(I9<=0,(G9-F9)/F9,(H9-G9)/G9),(I9-H9)/H9)
    > >
    > > "Elkar" wrote:
    > >
    > > > Ok, I'm still unclear what you're trying to do here. I don't see where an IF
    > > > Statement comes into play at all. Also, I'm not sure how your Columns A-D
    > > > relate to Columns F-I in your formula.
    > > >
    > > > That said, to get the percent differences, I think you can use these formulas:
    > > >
    > > > Difference from B to A: =(B9/A9)-1
    > > > Difference from C to B: =(C9/B9)-1
    > > > Difference from D to C: =(D9/C9)-1
    > > >
    > > > HTH,
    > > > Elkar
    > > >
    > > > "Phxlatinoboi®" wrote:
    > > >
    > > > > What I need to do is:
    > > > >
    > > > > Compare Column B to A and get the difference in %. Then I will compare C to
    > > > > B and get the different in % and then the same on Column D to C.
    > > > >
    > > > > Hope this makes sense.
    > > > >
    > > > > Phxlatinoboi®
    > > > >
    > > > > "Elkar" wrote:
    > > > >
    > > > > > You do have too many arguments. What your formula is saying:
    > > > > >
    > > > > > IF: I9 >=0
    > > > > > THEN: (G9-F9)/F9
    > > > > > ELSE: (H9-G9)/G9
    > > > > > ?: (I9-H9)/H9
    > > > > >
    > > > > > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    > > > > > accomplish we could help you write the formula.
    > > > > >
    > > > > > Elkar
    > > > > >
    > > > > > "Phxlatinoboi®" wrote:
    > > > > >
    > > > > > > My formual should look like this:
    > > > > > >
    > > > > > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    > > > > > >
    > > > > > > but I keep getting an error message saying too many arguments. How can I
    > > > > > > overcome this? Please advise.


  10. #10
    Phxlatinoboi®
    Guest

    RE: Need help with a formula

    Now the only thing left is that when I get my results in S9 it no
    longer changes color (ie red - negative, black positive)

    What can I do for that?


    "Elkar" wrote:

    > Ok, that makes more sense. Based on your description, I think this is what
    > you're looking for:
    >
    > =IF(I9<>0,(H9-I9)/I9,IF(H9<>0,(G9-H9)/H9,IF(G9<>0,(F9-G9)/G9,0)))
    >
    > A Nested statement is where you plug in a function as criteria within
    > another function. So, the above uses Nested IF Statements. So, if the first
    > part of the formula resolves to FALSE, then it will consult a second IF
    > Statement, and if that results to FALSE, then a third. You can "nest" up to
    > 7 functions.
    >
    > HTH,
    > Elkar
    >
    >
    > "Phxlatinoboi®" wrote:
    >
    > > Elkar,
    > >
    > > I have 5 cells i use. F9, G9, H9. I9 & S9. The values of cells are taken
    > > from another worksheet. What I am trying to do is this.
    > >
    > > if there is value in G9 minus that from F9 and divide by F9 to give me the %
    > > in S9. Now if there is value in H9 then I will minus that from G9 and divide
    > > it by G9 to get the % in S9. Now if there is value in I9 that will be minued
    > > from H9 and then divided by the value in H9 to get % for S9.
    > >
    > > The formula I want is in S9.
    > >
    > > Hope this makes sense.. Also, someone here mentioned I could nest and get
    > > the formula to work. What is nesting?
    > >
    > > The formual again that I want to use is:
    > >
    > > -if(I9<=0,(G9-F9)/F9,(H9-G9)/G9),(I9-H9)/H9)
    > >
    > > "Elkar" wrote:
    > >
    > > > Ok, I'm still unclear what you're trying to do here. I don't see where an IF
    > > > Statement comes into play at all. Also, I'm not sure how your Columns A-D
    > > > relate to Columns F-I in your formula.
    > > >
    > > > That said, to get the percent differences, I think you can use these formulas:
    > > >
    > > > Difference from B to A: =(B9/A9)-1
    > > > Difference from C to B: =(C9/B9)-1
    > > > Difference from D to C: =(D9/C9)-1
    > > >
    > > > HTH,
    > > > Elkar
    > > >
    > > > "Phxlatinoboi®" wrote:
    > > >
    > > > > What I need to do is:
    > > > >
    > > > > Compare Column B to A and get the difference in %. Then I will compare C to
    > > > > B and get the different in % and then the same on Column D to C.
    > > > >
    > > > > Hope this makes sense.
    > > > >
    > > > > Phxlatinoboi®
    > > > >
    > > > > "Elkar" wrote:
    > > > >
    > > > > > You do have too many arguments. What your formula is saying:
    > > > > >
    > > > > > IF: I9 >=0
    > > > > > THEN: (G9-F9)/F9
    > > > > > ELSE: (H9-G9)/G9
    > > > > > ?: (I9-H9)/H9
    > > > > >
    > > > > > The extra (I9-H9)/H9 doesn't fit. Maybe if you explained what you wanted to
    > > > > > accomplish we could help you write the formula.
    > > > > >
    > > > > > Elkar
    > > > > >
    > > > > > "Phxlatinoboi®" wrote:
    > > > > >
    > > > > > > My formual should look like this:
    > > > > > >
    > > > > > > =IF(I9<=0,(G9-F9)/F9,(H9-G9)/G9,(I9-H9)/H9))
    > > > > > >
    > > > > > > but I keep getting an error message saying too many arguments. How can I
    > > > > > > overcome this? Please advise.


+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1