Rounding UP of currency in a query

Hello All, I have spent far too much time researching this question on the Q&A of this site, So I have resorted to asking the wealth of experts chasing points.
What is the A2K equivalent of this Excel formula please
=CEILING(C2,0.1)
This happly upgrades figures like $13.02 to $13.10 or $32.58 to $32.60
I would like to imbed a rounding up formula in my Query that does the same please

Regards P
Paulo357Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
WeddehConnect With a Mentor Commented:
Round to 0.1
   INT(<field>*10*-1)/10*-1
Round to 1
   INT(<field>*-1)*-1
0
 
LennyGrayCommented:
Ccur(round(CurrencyAmount  + .50))
0
 
Paulo357Author Commented:
Sorry Lenny, you formula only rounded $13.02 to $14.00.
Weddeh, your formula  "INT(<field>*10*-1)/10*-1" is spot on rounding $13.02 to $13.10
cheers!
Paul
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
LennyGrayCommented:
No problem. I figured that you wanted rounding to the next dollar. Is that something particular to New Zealand?

I am happy that you were helped.

Who helps is not as important as who is helped.
0
 
Paulo357Author Commented:
No its not particular to NZ Lenny, its just I was tasked to do this rounding by my boss for a pricing senerio he is using
0
 
LennyGrayCommented:
Thanks
0
All Courses

From novice to tech pro — start learning today.