Increasing the value of cell and comparison

**qsebastian** · 03-10-2010, 03:55 PM

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** · 03-10-2010, 03:56 PM

Welcome to the forum.

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

Thanks.

**qsebastian** · 03-10-2010, 04:04 PM

Originally Posted by shg

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** · 03-10-2010, 04:40 PM

In C1: =A6-B3-B4

**qsebastian** · 03-10-2010, 04:54 PM

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...