• Status: Solved
• Priority: Medium
• Security: Public
• Views: 529

# 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
0
Paulo357
• 3
• 2
1 Solution

Commented:
Ccur(round(CurrencyAmount  + .50))
0

Commented:
Round to 0.1
INT(<field>*10*-1)/10*-1
Round to 1
INT(<field>*-1)*-1
0

Author 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

Commented:
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

Author 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

Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.