Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts

    Round to next dollar

    I have a simple Word formula, { = d4 * d5 }. If the result is not an even dollar amount, I would like to round up to the next dollar. If it is an even dollar amount, I want to leave it as it is. What must I add to the formula to achieve this?

    Thanks.

  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
    Richard,

    Either of these will work;
    Code:
    =ROUND(D4*D5+0.49,0)
    =INT(D4*D5+0.99)
    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Quote Originally Posted by richardbarrett View Post
    I have a simple Word formula, { = d4 * d5 }. If the result is not an even dollar amount, I would like to round up to the next dollar. If it is an even dollar amount, I want to leave it as it is. What must I add to the formula to achieve this?
    Assuming the amounts are always whole dollars, try:
    {=INT(D4*D5)+(MOD(INT(D4*D5),2)>0) \# "$,0.00"}
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  4. #4
    5 Star Lounger
    Join Date
    Mar 2001
    Location
    New York, NY
    Posts
    922
    Thanks
    2
    Thanked 12 Times in 11 Posts
    Thank you to both of you.

Posting Permissions

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