VBA increment value until a condition is met

[RPM7]

Would anyone be able to help me with the following VBA?
I've no idea of how to do it.

If D15 < K15, then increment Y15 value+1 (This would need to loop until the condition is met)
Then go to next row and check the same.

This would have to apply to rows 15 to 44

Thanks

 

[RPM7]

Thanks for the update @footoo, unfortunately the updated macro didn't work.
I've been using the original macro you sent and to be honest, it's actually working great for me.
I like being able to monitor the increments.

I have tried modifying your macro on another worksheet to include an 'OR' statement, but it tends to continue incrementing each row regardless of the conditions being met.
It only stops when every row has met the 3 conditions.

Do you know what I might be doing wrong?

Sub BSJF_increment()

[AA15:AA44] = Evaluate("IFERROR ( IF ( or ( W15:X44<K13 , BJ15:BJ44<BH15:BH44 , BK15:BK44<BI15:BI44 ) , (AA15:AA44)+1 , AA15:AA44) , """")")

End Sub

 

[footoo]

What do want from this :

 W15:X44<K13

Does it mean any cell in columns W:X of the same row less than cell K13 ?

 

[RPM7]

What do want from this :

 W15:X44<K13

Does it mean any cell in columns W:X of the same row less than cell K13 ?

Yes, K13 is a fixed value.

It works with the following:

[AA15:AA44] = Evaluate("IFERROR ( IF ( W15:X44<K13 , (AA15:AA44)+1 , AA15:AA44) , """")")

I can get also the following two vba examples work independently, but when I try to combine two or more conditions with an "OR" statement, I have issues.

[AA15:AA44] = Evaluate("IFERROR ( IF ( BJ15:BJ44<BH15:BH44 , (AA15:AA44)+1 , AA15:AA44) , """")")

[AA15:AA44] = Evaluate("IFERROR ( IF ( BK15:BK44<BI15:BI44 , (AA15:AA44)+1 , AA15:AA44) , """")")

 

[footoo]

Try this :

[AA15:AA44] = Evaluate("IFERROR(IF((W15:W44<$K$13)+(X15:X44<$K13)+(BJ15:BJ44<BH15:BH44)+(BK15:BK44<BI15:BI44),(AA15:AA44)+1,AA15:AA44),"""")")

 

[RPM7]

Try this :

[AA15:AA44] = Evaluate("IFERROR(IF((W15:W44<$K$13)+(X15:X44<$K13)+(BJ15:BJ44<BH15:BH44)+(BK15:BK44<BI15:BI44),(AA15:AA44)+1,AA15:AA44),"""")")

That worked perfectly, thanks.