Hi,
Assuming that we have a target number which is 15000 in Column C. Column B is blank and Column A has 1.
The requirement is that when a number is entered in Column B, say 10000, if the number is less than Column C , which is 15000, is there a method that the number in Column A that is 1 is added to Column B until Column B matches Column A?
Something like the if(B1<C1), B1+A1. However, this formula just adds 1 to B1 making it 10001 rather than keep adding until 15000 is reached.
Does this require VBA? Could you please help?
Regards,