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.