VBA- Rounding a static value to closest increment of a Loop/Array created from another static value

[shazbatz]

INCREMENT	STATIC 1	STATIC 2	VALUE
.25	100	100.35
.45	200	201.55
.65	300	302.75

<tbody>
</tbody>

I'm struggling to figure out in VBA the most efficient way to create a loop/array within the value in the STATIC 1 column using the increment in same row, and then rounding the STATIC 2 value in same row to nearest element within the loop/array to derive the desired VALUE in blank column.

Example loop/array for first row with .25 increment and 100:
99.25 99.50 99.75 100 100.25 100.50 100.75

Rounding the 100.35 to nearest element of 100.25, thus making 100.25 the desired value in blank cell

And so on for additional rows creating the loops/arrays based on coinciding increments

 

[footoo]

Here's a worksheet formula (which can be entered in the VALUE column with a macro if required) :

=B2+(A2*ROUND((C2-B2)/A2,0))

 

[shazbatz]

Here's a worksheet formula (which can be entered in the VALUE column with a macro if required) :

=B2+(A2*ROUND((C2-B2)/A2,0))

That worked perfectly. Thank you

What if the values in column C are not static? Can a formula be utilized to capture the non-static value at a specific time using the Windows clock time?

 

[footoo]

What if the values in column C are not static? Can a formula be utilized to capture the non-static value at a specific time using the Windows clock time?

Provided you have calculations set to automatic, the formula will automatically account for any changes in column C.

 

[shazbatz]

That makes sense. Thanks for the quick lessons bud.