Hello All,

First time posting here but I am stuck. Normally I can tie together parts from amazing responses here to figure it out but not this time. What I want to accomplish it to reduce a cell value by 1 until an equation equals a full integer. Replacing C1 below with A1 -1 until C1 is an integer.

A1=500
B1=15
C1= cell starting at 500 (or A1) reducing by 1 until D1 = integer
D1 = ((A1/2)/B1)*100)

492 is what C1 should say and D1 should be 1640 if the loop runs correctly