Formula to Round to Nearsest $25

[kevinb11]

I am thinking I can use MRound but not Sue how get it to round down to nearest $25

 

[dreid1011]

Have you tried it and it is not giving you the desired results?

 

[Asbestos_Jen]

The floor function will work if you always want it to round down.

Book1
	A	B
1	Raw	Down25
2	2047.5	2025
3	1800	1800
4	180	175
5	1845	1825
6	90	75
7	202.5	200
8	427.5	425
9	135	125
10	427.5	425
11	1935	1925
Sheet1

Cell Formulas
Range	Formula
B2:B11	B2	=FLOOR(A2,25)

 

[kevinb11]

The floor function will work if you always want it to round down.

Book1
	A	B
1	Raw	Down25
2	2047.5	2025
3	1800	1800
4	180	175
5	1845	1825
6	90	75
7	202.5	200
8	427.5	425
9	135	125
10	427.5	425
11	1935	1925
Sheet1

Cell Formulas
Range	Formula
B2:B11	B2	=FLOOR(A2,25)

Perfect. Thank you!!

 

[Asbestos_Jen]

Thanks for the feedback. Glad to help.