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.
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.
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.
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.
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.
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.
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.
"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.
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.
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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks