Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Hampered by MS word's field code limits
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...- dipstik
- Post #19
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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%...- dipstik
- Post #18
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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...- dipstik
- Post #15
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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...- dipstik
- Post #12
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
elegant and functional. thank you very much.- dipstik
- Post #9
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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...- dipstik
- Post #7
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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...- dipstik
- Post #5
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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...- dipstik
- Post #3
- Forum: Microsoft: Office
-
Hampered by MS word's field code limits
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...- dipstik
- Thread
- Replies: 18
- Forum: Microsoft: Office
