How can I round my prices UP to, say, the nearest 10p? (They get arrived at based on commissions and various things that result in prices like £6.23 which, a test user has just told me, looks “untidy, unfriendly and weird” so I thought I’d help by rounding them to the nearest 10p to make them, presumably “tidy, friendly and normal” (and better for my bottom line!)
I’ve been playing with “:Rounded to” but this rounds down as well as up depending on the decimal. :Ceiling seems to work with integers so when it comes to prices then £6.03 becomes £7 which is a big old jump, :Floor does the same but downwards. Is there another way of doing this? My brain tells me that adding £0.05 to the total and then using “:Rounded to” might work but I’m not mathematically minded and I’m worried that this would go wrong in a costly way somehow.