P Patty Hatridge Jan 7, 2004 #1 I need a formula that rounds the result of a calculation to a number exactly divisible by 250.
J Jeff Sward Jan 7, 2004 #2 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'.
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'.
B Beto Jan 7, 2004 #3 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,
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,
