I am sure I am being silly here
using ROUND(1499) is just 1499 isnt it?
how.. how do I round to 1500?
(it's for a price, so for example a laptop price. It makes more sense to say it's 1500)
The answer depends on what you want. Do you want 1498 to round to 1500? If you do, the answer will be different. I need to know what numbers round up.
Do you need this to work with negative numbers, or just positive numbers?
Do you need this to work with pennies/fractions, or just whole numbers? Eg, 1498.98
Here's a simple way to round to the nearest $10. Replace 1495 with your variable name.
2 Likes