Hello,
Please let me explain what I am trying to do first so it makes sense. I have tried to research it but have not found any answers. Thank you for any help. I need to divide the numbers in two different cells. That is easy enough. What I need to do from there though, is but the whole integer in one cell and the remainder in another. I am creating a spreadsheet to keep track of sales. If you buy one of my product it is $5, if you buy 2, it is $8. I need to take the total ordered and divide it by 2 to find the number of $8 deals a customer gets. If it is an odd number and there is a remainder of .5, I need to put that into another column and round it up to 1. That way I can add up the totals of $8 deals and $5 deals. Any advice on the best way to go about this? Thank you!