We raised a $20m Series A led by Coatue + Accel! Click here to read the announcement.

Google Sheets

The ROUNDDOWN function in Google Sheets is used to round a number down to the nearest integer. For example, if you enter the number 9.5 into the function, it will return the number 9.

The syntax of ROUNDDOWN in Google Sheets is to use the function name followed by the number of decimal places to round to. For example, the syntax for rounding down to the nearest whole number is ROUNDDOWN(number, 0).

One way to use the ROUNDDOWN function in Google Sheets is to round a number down to the nearest whole number. For example, the following formula would round the number 5.5 down to 5: =ROUNDDOWN(5.5, 0)

Another way to use the ROUNDDOWN function is to round a number down to a specific number of decimal places. For example, the following formula would round the number 5.5 down to 2 decimal places: =ROUNDDOWN(5.5, 2)

The ROUNDDOWN function can also be used in combination with the IF function to create a conditional rounding rule. For example, the following formula would round the number 5.5 up to 6 if it is greater than 5, and round it down to 5 if it is less than or equal to 5: =IF(5.5>5, 6, 5)

There are a few occasions when you should not use the ROUNDDOWN function in Google Sheets. One such situation is when you need to calculate a percentage. In this case, you should use the ROUND function instead. Another time you should not use ROUNDDOWN is when you are working with decimals and need to keep track of the number of decimal places. In this case, you should use the ROUND function instead.

There are a few similar formulae to ROUNDDOWN in Google Sheets. One is ROUNDDOWN.INT, which rounds a number down to the nearest integer. Another is ROUNDDOWN.PRECISION, which rounds a number down to a specific number of decimal places. Finally, there is ROUNDUP.INT, which rounds a number up to the nearest integer.

Get started with Causal today.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.

Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.