Round result to a specific ending number

[Annoyed2024]

I'm setting up a spreadsheet to make price tags. I will have one cell where I input a number (and for my question I'll call it cell A2). I will have two other cells that will calculate a figure based on the input number in A2. The hiccup is that I want the result to round to a specific ending number with each result. So for example I put 200 in A2. The result would be 242.68 but I would want the result to round up to a whole number ending in 4. in this case it would round up to 244. If I entered 435, in cell A2, the result would be 637.25 so I would want it to round to 644. Is there a way to do this with a formula?

 

[JumpingCrab]

If the value you want to round to is in cell A1 (say A1 = 4), then you can round the value in A2 to multiples of the value in A1 like this:
=ROUND(A2/A1,0)*A1

 

[Tetra201]

Maybe
=ROUNDUP(your_formula+6,-1)-6

 

[Phuoc]

Maybe like this:

=ROUND ( your_formula, - 1 )+ 4

 

[Phuoc]

The two formulas have different results, which formula do you choose?:

Book1
	A	B	C
1		Tetra201	Phuocam
2	242.68	244	244
3	637.25	644	644
4	101	104	104
5	104.01	114	104
Sheet1

Cell Formulas
Range	Formula
B2:B5	B2	=ROUNDUP(A2+6,-1)-6
C2:C5	C2	=ROUND(A2,-1)+4