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.