Jump to content

This topic is 7471 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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

Posted

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.