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)) |
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>
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>
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).
Isn't that what you asked for originally?Now I get "0.25" even if original cell value is "0".
but I can't use a "0.00" value (I need min. 0.25) -- what can I do?