Search results for query: *

acually, i had to change the mod-equal-to value to something completely different. my main goal was to find something that would go between two numbers when checking the critical values, but when i multiply everything by the same order or 10 i end up with similar mod values for all critical...

Yeah, i need the even rounding scheme... i'm having some weird problems in excel though... i have a mod test in an if statement like so: So, I started with this for stuff under 10%: IF(MOD(2*B2,0.02)=0.005,ROUND(2*B2-0.000001,2)/2,ROUND(2*B2,2)/2) and this for stuff over 10%...

perfect. now i need something to round to the nearest 0.2 percent... im trying =IF(MOD(500*B19/8,1)=0.5,(ROUND(500*B19/8,0)/5)-0.2*(MOD(500*B19/8,2)<>0)) and =100*ROUND(B19*5/8-(MOD(B19/8,0.004)=0)*(MOD(ROUND(B19*5/8,0)/5,0.016)<>0),2)/5 but i cant get the alternate rounding to work out...

for some reason i am getting a "!syntax error, )". the formula works fine in excel, and the entire formula will fit in a form field, but a form field will not spit out any result at all. I used the formula field as you suggested and the error above is the result for some reason. I would think...

elegant and functional. thank you very much.

looks like we are getting closer, but I am getting 49100 as a return for 49150. I should be getting 49200. I would also appreciate any explaination of the boolean application of the mod function, since i would think that mod(x,y) would just return the remainder of x/y, but i see the formula...

yes, that is my intention. the standard states that all middle values must be rounded to the nearest even number. if you are rounding to the nearest 100, then 150 would go to 200 as would 250. when you have to round to the nearest non-decimal figure, such as nearest 500, then you must...

that would not address the rounding to evens protocol. 1650 would be rounded to 1700 instead of 1600. and 60250 would give me 60500 instead of 60000. is there any way to add these functions to word? a plugin or add-in or something? i can try to use the script editor if someone sees a...

Hi all, I am trying to round mid-way numbers to the closest even numbers with a certain precision for three seperate ranges: 0-50k,50 to 100k and over 100k with precisions 100, 500 and 1000 respectivly (round 1.5 to 2 and 2.5 to 2 and for non decimal rounding multiply the value, apply rounding...