google sheets
Selling something by bundles of 10, and want to try and calculate how many bundles and the price.
32 purchased / 10 bundle size = 3.2
Want to round 3.2 up 4 bundles.
Tried the ROUND() function but that rounds up and down. I always need to round up.
Searched around, found ways to prevent rounding, but not how to specifically round up always to nearest whole number.
The function VLOOKUP is only usable within a spreadsheet. This means that you use sheets !!
Therefore I created a sample, based on sheets.
If you want to use spreadsheets however, then study the IMPORT function or Google Apps Script.
Remarks to the example:
File I prepared with working example
Adding a sample of you own, helps a great deal to better understand what you mean !!
UPDATE: I've added edit rights to the example file I created, so you can play with it. Changed the names as well, each now being different (makes the auto-complete function work)
Wouldn't a more simple way of doing this be done using functions in the actual sheet?
Up: =MROUND(A1+0.25;0.5)
Down: =MROUND(A1-0.25;0.5)
I would assume that having another column added to the spreadsheet that takes the Google Forms input and performs the rounding function on it, then use Apps Script to email the data would be easier than than trying to do it all in a script.
Best Answer
Found a way.
=ROUNDUP(3.2,0)Which results in 4. The ROUNDUP function takes an argument, which tells it how many decimal places to round to. 0 means whole number.
https://support.google.com/docs/answer/3093443?hl=en