Excel 2007 : Increasing the value of cell and comparison

[qsebastian]

Can somebody help me?
Please show me how to do something with IF function.
In row 4 i have sum of column B and column C.
I want to compare the cell B4 and C4.
I want to increase the value of cell C1, with adding the number 1 until the C4=B4


-------A-----B-----C
1-------------3-----1
2-------------5-----3
3-------------9-----4

4------------17----8 ----this is sum


=IF(C4<B4;C1+1;C4) ??

..with this way, the result is 2, because IF function do adding just one time...
..help...tnx...

[shg]

Welcome to the forum.

Please take a few minues to read the forum rules, and then amend your thread title accordingly.

Thanks.

[qsebastian]

Welcome to the forum.

Please take a few minues to read the forum rules, and then amend your thread title accordingly.

Thanks.

ok, i will do that..

thanks...

[shg]

In C1: =A6-B3-B4

[qsebastian]

hm, maybe i wasn't clear enough...
i want that the value in cell C1 increase repeatedly,from value which is already in the cell, step by step, until C4 = B4...

[shg]

No formula is going to do that. The formula I gave you will make the totals in B4 and C4 the same.

[qsebastian]

ok, but can i do something in Visual Basic maybe, something with functions IF, THEN, ELSE ?