★0 XP
Question 1 of 10
The FLOOR function in Excel rounds a number (the first argument) down to the nearest multiple of the second argument.
To round the price DOWN to the nearest 1 dollar, type =FLOOR(B1, 1)
To round the price DOWN to the nearest 1 dollar, type =FLOOR(B1, 1)
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Price: | 1.99 | ||
| 2 | ||||
| 3 | ||||
| 4 | ||||
| 5 |
B2fx