Find max/min values that will round to the same number

[chris0b]

Is there a way to find the maximum and minimum values that round to the same number in a calculation?

My work laptop doesn't let me install the XL2BB but I will try to explain

round(9.35/37.5,2)=0.25
round(9.41/37.5,2)=0.25

If I try to reverse the calculation 0.25*37.5 I get 9.375 (or 9.38 if rounded).
Is there a way to find the maximum and minimum values that will also round to 0.25 (or any figure I choose) in the same calculation?

 

[Artik]

Have you tried using the MROUND function?

Artik

 

[Phuoc]

Min: ROUND(0.245,2) = 0.25 => 0.245*37.5 = 9.1875

Max: ROUND(0.254999,2) = 0.25 => 0.254999*37.5 = 9.5624