Stop formula counting when it is equal to another cell?

Hello Everyone!,

I need a formula modified (below) in order to stop when it is equal to cell C6.
The below formula is in cell AF150 and will produce a number:

=IF(COUNTIF(D10:Y10,">0")>TODAY()-C3,COUNTIF(D10:Y10,">0"),TODAY()-C3)

Cell C3 contains a date (start date). As each day goes by the above formula will take today's date and minus the start date (Cell C3) giving a number.

This works fine but I do not want the number that it produces to continue counting when it is equal to cell C6 (cell C6 just contains a number only no formulas at all).
I would like to stop cell AF150 adding when the number it produces is the same as the number in cell C6.

So basically cell C6 contains the number 8 (for example) and when cell AF150 displays the number 8 I want it to stop and not display 9 or above. I do not want it to count past number 8 (or whatever number cell C6 contains).

Thank you very much for any help, I am totally confused!

Regards,

Margate

Hi Margate,

Perhaps something like this:

Please Login or Register  to view this content.

This should make the cell output the value of C6 anytime that the formula you wrote would give a value above the value of C6.

I hope this helps.

=IF(COUNTIF(D10:Y10,">0")=C6,"whatever_you_want_here,IF(COUNTIF(D10:Y10,">0")>TODAY()-C3,COUNTIF(D10:Y10,">0"),TODAY()-C3))

Perfect! Thank you very much RGrunden, this is exactly what I was looking for

Margate