formula for rounding

  • Thread starter Thread starter Patty Hatridge
  • Start date Start date
P

Patty Hatridge

I need a formula that rounds the result of a calculation
to a number exactly divisible by 250.
 
temp = x mod 250
if(temp<250/2)
res = x-temp
else
res = x + (250-temp)

mod is a standard arithmetic operator that returns the remainder of x
divided by y. not sure what the syntax is for VB in most other languages
it's % or 'mod'.
 
Patty said:
I need a formula that rounds the result of a calculation
to a number exactly divisible by 250.
Click to expand...

=ROUND(A1/250,0)*250

Assuming the number to be rounded is in A1. YOu might want to check the
name of the function (ROUND), because I use Excel in spanish (REDONDEAR).

Regards,
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formula needed to round up a value to a whole number 5
Excel Stop Excel from displaying rounded values 4
Excel Assistance with Fomula 0
Round calculations 1
add Rounding function to this formula 2
Use a Variable in a formula 4
Wrong data type returned from user-defined function 9
Excel Excel 2007 won't stop rounding down my formula results! 5

Back
Top