Originally Posted by

**trixma**
I have a problem with my IF statement it wont stop at the correct answer for example

I have IO = 20 000

Y1 cash flow = 5 000

Y2 cash flow = 5 000

Y3 cash flow = 10 000

Y4 cash flow = 25 000

Im using the following IF statement

=IF(5000>20000,1+(20000-5000)/20000,

IF(5000+5000>20000,2+((20000-5000)-5000)/20000,

IF(5000+5000+10000>20000,3+(((20000-5000)-5000)-5000)/20000,

IF(5000+5000+10000+25000>20000,4+((((20000-5000)-5000)-5000)-25000)/20000))))

I rewrote my equation so the numbers make sense but i am using cell references so if the IO or cash flow changes the answer will change too.

Using my equation the answer should be 3 but it moves to the next true if statement.

My question is how do i stop the equation from moving to the next true if statement. The equations are correct but im having trouble stopping the equations at the correct answer. In this case being the third if statement.

## Bookmarks