ronnie524 Posted September 15, 2004 Posted September 15, 2004 I have a field that calculates the price of a product with 30% added on the cost; but I need the price automatically rounded off to the nearest .25 e.g: 4.50+30%=5.85 (i was looking for it to show= $6.00) e.g2: 4.75+30%=6.175 (i was looking for it to show=6.25) What do i put in the calculation to give me that answer? Thank you in advance
-Queue- Posted September 15, 2004 Posted September 15, 2004 Int(price + price * 0.3) + .25 * (Int((price + price * 0.3 - Int(price + price * 0.3)) * 100 / 25) + not not Mod( (price + price * 0.3 - Int(price + price * 0.3)) * 100, 25 ))
Recommended Posts
This topic is 7471 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now