Hello Folks,
I'm trying to use the MROUND function with an IF statement. I need values in Column "A" to be rounded off to the next multiple of 3 if the value is less than or equal to 42. If the value exceceds 42 it needs to be rounded of to the next multiple of 6. The issue I have is that if the value in column "A" is 1 the formula rounds it down to 0.
4 becomes 3
7 becomes 6 so on and so forth.
Is there a way we can tweak the formula to keep the value in column "A" as a minimum instead or rounding it down to the closest multiple of 3 ? so the 4 stays as four instead of becoming a 3.
Please help! I am not sure if i'm explaining my problem clearly please let me know if there any questions. thanks
This is the formula i'm using =IF(A2<42,MROUND(A2,3),MROUND(A2,6))
<colgroup><col><col></colgroup><tbody>
</tbody>
I'm trying to use the MROUND function with an IF statement. I need values in Column "A" to be rounded off to the next multiple of 3 if the value is less than or equal to 42. If the value exceceds 42 it needs to be rounded of to the next multiple of 6. The issue I have is that if the value in column "A" is 1 the formula rounds it down to 0.
4 becomes 3
7 becomes 6 so on and so forth.
Is there a way we can tweak the formula to keep the value in column "A" as a minimum instead or rounding it down to the closest multiple of 3 ? so the 4 stays as four instead of becoming a 3.
Please help! I am not sure if i'm explaining my problem clearly please let me know if there any questions. thanks
This is the formula i'm using =IF(A2<42,MROUND(A2,3),MROUND(A2,6))
| Value | Rounded Value |
| 1 | 0 |
| 2 | 3 |
| 3 | 3 |
| 4 | 3 |
| 5 | 6 |
| 6 | 6 |
| 7 | 6 |
| 8 | 9 |
| 9 | 9 |
| 10 | 9 |
| 11 | 12 |
| 12 | 12 |
| 13 | 12 |
| 14 | 15 |
| 15 | 15 |
| 16 | 15 |
| 17 | 18 |
| 18 | 18 |
| 19 | 18 |
| 20 | 21 |
<colgroup><col><col></colgroup><tbody>
</tbody>
