First time here? Check out the FAQ!

1 | initial version |

If your idea is to round to a class (e.g. every 5 cm) then yes, it is possible. You need to use a simple formula instead of a function.

For a 5cm class you would do =(INT((A2-0,1)/5)+1)*5 This will result in 8 rounded to 10, 13 rounded to 15, etc

There are two important details: +1 is added so that the number is rounded up (remove it if you want it rounded down); -0.1 is subtracted so that 5 is included in the 5 class and not in 10 (remove this if you are rounding down or if you prefer your classes open on the upper limit)

2 | No.2 Revision |

If your idea is to round to a class (e.g. every 5 cm) then yes, it is possible. You need to use a simple formula instead of a function.

For a 5cm class you would do ~~=(INT((A2-0,1)/5)+1)*5
~~=(INT((A1-0,1)/5)+1)*5
This will result in 8 rounded to 10, 13 rounded to 15, etc

There are two important details: +1 is added so that the number is rounded up (remove it if you want it rounded down); -0.1 is subtracted so that 5 is included in the 5 class and not in 10 (remove this if you are rounding down or if you prefer your classes open on the upper limit)

3 | No.3 Revision |

If your idea is to round to a class (e.g. every 5 cm) then yes, it is possible. You need to use a simple formula instead of a ~~function.~~function or cell formatting.

For a 5cm class you would do =(INT((A1-0,1)/5)+1)*5 This will result in 8 rounded to 10, 13 rounded to 15, etc

There are two important details: +1 is added so that the number is rounded up (remove it if you want it rounded down); -0.1 is subtracted so that 5 is included in the 5 class and not in 10 (remove this if you are rounding down or if you prefer your classes open on the upper limit)

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.