Paulo357
asked on
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
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
Ccur(round(CurrencyAmount + .50))
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
Weddeh, your formula "INT(<field>*10*-1)/10*-1"
cheers!
Paul
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.
I am happy that you were helped.
Who helps is not as important as who is helped.
ASKER
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
Thanks