Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jan 2015
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Mail Merge need to round up

    Is it possible to make any number that is not whole round UP to the next value. Using the switch\#0 only rounds it to the nearest number.
    For example {196/12\#0} is giving me 16 and I need it to show 17

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    T.M.

    Just add 0.5 to the number and you'll get what you want, e.g. {(195/12)+0.5\#0} HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •