I'm using mod in an IF statement in a mergefield in a word document pulling data from an access database.
I cannot copy the If statement into here, but if you can imagine parentheses, the following statement works for an interest rate, say 4.375, it returns 4
I am using it successfully with an interest rate If =Mod Mergefield interestrate,1 =0" Mergefield Interestrate\#";;" " etc.
I am trying to do something similar with a dollar field like 211,000.00, if I divide that by 1, I would get 211,000 . So in the IF Statement how would I express a remainder of nothing. I have tried IsNull, I have tried " ". I have tried .00.
I just want to strip off the .00 from this currency field.
Thanks for any suggestions.