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

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
Asked:
Paulo357
  • 3
  • 2
1 Solution
 
LennyGrayCommented:
Ccur(round(CurrencyAmount  + .50))
0
 
WeddehCommented:
Round to 0.1
   INT(<field>*10*-1)/10*-1
Round to 1
   INT(<field>*-1)*-1
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
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
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
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now