How can I make the answer to an if statement division problem display a whole number and take the remainder of that value for a formula in another cell? Sorry new to numbers.
Cubic Yards to size of dumpster and quantity. a2 is total cu yds, b2 is text from if statement showing size of dumpster depending on value of a2 (15yd, 20yd, 30yd), and c2 is an if statement that provides quantity of dumpsters needed of the given size. This comes out as a whole number with a decimal.