Rounding (up or down) to the nearest 25

[mcgonma]

Is there a formula that can be used so that the result of a calculation is then rounded either up or down to the nearest 25.
e.g., if the result is 107, the final number would actually change then be 100; or, if the calculated value was 63, the final number would be 75.

 

[Bosquedeguate]

Try this formula:
=INT(A40/25)*25 + IF(MOD(A40,25)>12,25,0)

 

[Bosquedeguate]

Try this formula:
=INT(A40/25)*25 + IF(MOD(A40,25)>12,25,0)

Note: A40 contained my test value, the formula was in B40

GetLastRow.xlsm
	A	B
40	82	75
Sheet1

Cell Formulas
Range	Formula
B40	B40	=INT(A40/25)*25 + IF(MOD(A40,25)>12,25,0)

 

[mcgonma]

Note: A40 contained my test value, the formula was in B40

GetLastRow.xlsm
	A	B
40	82	75
Sheet1

Cell Formulas
Range	Formula
B40	B40	=INT(A40/25)*25 + IF(MOD(A40,25)>12,25,0)

Is there a way to have this all be part of a cell that is pulling data from other places?
For example:
Currently, B43=B140+B232+B248+B264 and the result is 3,027. I would like to instead have the result be 3,025.
Similarly, B51=B148+B233+B249+B265 and the result is 716. I would like the result to 725 instead

 

[Bosquedeguate]

If this resolves your problem please flag your post as "Solved".

 

[Bosquedeguate]

Replace the Cell reference with SUM(range) in both parts of the formula: (see example below)
Cells C41 to F41 are SUMmed, then SUM result is rounded.

GetLastRow.xlsm
	B	C	D	E	F
41	1175	10	20	30	1111
Sheet1

Cell Formulas
Range	Formula
B41	B41	=INT(SUM(C41:F41)/25)*25 + IF(MOD(SUM(C41:F41),25)>12,25,0)

 

[mcgonma]

Replace the Cell reference with SUM(range) in both parts of the formula: (see example below)
Cells C41 to F41 are SUMmed, then SUM result is rounded.

GetLastRow.xlsm
	B	C	D	E	F
41	1175	10	20	30	1111
Sheet1

Cell Formulas
Range	Formula
B41	B41	=INT(SUM(C41:F41)/25)*25 + IF(MOD(SUM(C41:F41),25)>12,25,0)

THIS IS PERFECT!!!!! Thank you so much!!!!!

 

[AhoyNC]

Another option is to use the MROUND function.

Book2
	A	B	C	D	E	F
1	1175	10	20	30	1111	2350
Sheet3

Cell Formulas
Range	Formula
F1	F1	=MROUND(SUM(A1:E1),25)