close
close

Google Sheets Math Floor

Google Sheets Math Floor. Description the google sheets floor function returns a number rounded down to the nearest multiple of significance. #1 to round the value in b1 cell down to nearest multiple of 2, just using the following excel formula:

MultiDigit Multiplication Digital Math Pixel Art Mystery
MultiDigit Multiplication Digital Math Pixel Art Mystery from www.teacherspayteachers.com

Instead of using the cell references in the floor formula in column c, you can use the formulas as below. In this formula 8 is the “value” and 3 is the “factor”. This can be used, for instance, to round down to a particular denomination.

(more…)