"MROUND" - Need Min. 0.25 Value

[jcarey]

I am utilizing "MROUND" to round to values of 0.25, 0.50, 0.75 & 1.00 - it works great, but I can't use a "0.00" value (I need min. 0.25) -- what can I do?

 

[dreid1011]

Perhaps something like this:

=MAX(0.25,MROUND(A1,0.25))

 

[MrKowz]

Something like this?

Excel 2013/2016
	A	B	C
1	Value	Mround Result	Min 0.25 Result
2	3.06028	3	3.25
3	6.871777	6.75	6.75
4	7.759659	7.75	7.75
5	3.54384	3.5	3.5
6	8.672333	8.75	8.75
7	7.34081	7.25	7.25
8	4.940666	5	5.25
9	9.664757	9.75	9.75
10	1.269969	1.25	1.25
11	6.875821	7	7.25
12	3.840254	3.75	3.75
13	2.429647	2.5	2.5
14	8.051095	8	8.25
15	3.753301	3.75	3.75
16	6.324389	6.25	6.25
17	10.0269	10	10.25
2

Cell Formulas
Range	Formula
B2	=MROUND(A2,0.25)
C2	=IF(MROUND(A2,0.25)=ROUND(A2,0),ROUND(A2,0)+0.25,MROUND(A2,0.25))

 

[jcarey]

Something like this?

Excel 2013/2016

	A	B	C
1	Value	Mround Result	Min 0.25 Result
2	3.06028	3	3.25
3	6.871777	6.75	6.75
4	7.759659	7.75	7.75
5	3.54384	3.5	3.5
6	8.672333	8.75	8.75
7	7.34081	7.25	7.25
8	4.940666	5	5.25
9	9.664757	9.75	9.75
10	1.269969	1.25	1.25
11	6.875821	7	7.25
12	3.840254	3.75	3.75
13	2.429647	2.5	2.5
14	8.051095	8	8.25
15	3.753301	3.75	3.75
16	6.324389	6.25	6.25
17	10.0269	10	10.25

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

2​

Worksheet Formulas Cell Formula B2 =MROUND(A2,0.25) C2 =IF(MROUND(A2,0.25)=ROUND(A2,0),ROUND(A2,0)+0.25,MROUND(A2,0.25)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

I will try this...

 

[jcarey]

Something like this?

Excel 2013/2016

	A	B	C
1	Value	Mround Result	Min 0.25 Result
2	3.06028	3	3.25
3	6.871777	6.75	6.75
4	7.759659	7.75	7.75
5	3.54384	3.5	3.5
6	8.672333	8.75	8.75
7	7.34081	7.25	7.25
8	4.940666	5	5.25
9	9.664757	9.75	9.75
10	1.269969	1.25	1.25
11	6.875821	7	7.25
12	3.840254	3.75	3.75
13	2.429647	2.5	2.5
14	8.051095	8	8.25
15	3.753301	3.75	3.75
16	6.324389	6.25	6.25
17	10.0269	10	10.25

<colgroup><col style="width: 25pxpx"><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

2​

Worksheet Formulas Cell Formula B2 =MROUND(A2,0.25) C2 =IF(MROUND(A2,0.25)=ROUND(A2,0),ROUND(A2,0)+0.25,MROUND(A2,0.25)) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Having trouble.
I don't know if it's because the cell I'm trying to round is pasted as a link from another worksheet or not.
Here's my formula...

=MROUND('C:\Users\jcarey\Desktop\Temp - Time Sheet\[00) 00.00.0000 - 00.00.0000_Hour Tracker.xlsx]Sheet1'!$Y$8,0.25)

What might I be doing wrong?

 

[MrKowz]

Are you receiving an error? Is the formula returning any value? If so, what?

 

[jcarey]

It gave me a warning of circular formula at first, but then I hit "Okay" and I still got a value of "0".

 

[Joe4]

If you are getting a circular formula error, it probably means that you mistyped the cell address in your formula, and you used the cell address of the cell that you are placing the formula in!
The formula should be reference cells where data exists (not where you are putting this formula).

 

[jcarey]

If you are getting a circular formula error, it probably means that you mistyped the cell address in your formula, and you used the cell address of the cell that you are placing the formula in!
The formula should be reference cells where data exists (not where you are putting this formula).

I fixed referencing the cells of the original file.
Now I get "0.25" even if original cell value is "0".

 

[Joe4]

Now I get "0.25" even if original cell value is "0".

Isn't that what you asked for originally?

but I can't use a "0.00" value (I need min. 0.25) -- what can I do?

I am guessing that you have not communicated exactly what you want very clearly.
You may do better to provide us with a bunch of examples, and the results you would like to see.