Obtain number which is highest multiple of specific constant

hallo,

please help me with a formula that will change (alter slightly), a number to become a multiple of a given constant. Example: If I have a value 1347.70, and I want this number to be a multiple of 7.50, the highest number would be 1342.50. Please help. Thank you all very much..

Perfect!!, thank you very much, have a lovely day..

Hi Pangam,

thank you, your formula also works great!!..have a nice day..

Please use below formula to alter the number

Cell a1= 1347.7
Cell b1= 7.5
Formula in any cell =A1-MOD(A1,B1)

Try this formula.

=INT(ROUND(K17/M17;2))*M17

K17 is your value 1437.70
M17 is your value 7.50