Results 1 to 5 of 5

Round Up Funtion

Threaded View

  1. #1
    Registered User
    Join Date
    01-16-2019
    Location
    Texas
    MS-Off Ver
    2016
    Posts
    2

    Round Up Funtion

    Good evening community,

    Using some bank transaction data, I would like the amount it takes to round to the nearest whole dollar displayed.

    For instance: the transaction amount is $326.35. I would like the $.35 to be rounded to the nearest whole dollar. The amount I would like displayed in a separate cell would be $.65, the amount it took to round to the nearest whole dollar.

    Thanks for your help community!

    CMUMPH
    Last edited by AliGW; 01-17-2019 at 02:13 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. how to lock or freeze today funtion and Now funtion
    By edwest01 in forum Excel General
    Replies: 2
    Last Post: 12-09-2018, 06:35 PM
  2. [SOLVED] Custom formulas that will round up when a condition is met or round down
    By cinstanl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-20-2016, 01:32 PM
  3. Replies: 5
    Last Post: 01-30-2015, 11:34 AM
  4. Replies: 2
    Last Post: 12-06-2014, 01:58 PM
  5. [SOLVED] How to round to nearest .01 and round down if thousands place is .005
    By dredre609 in forum Excel General
    Replies: 5
    Last Post: 09-29-2014, 11:47 AM
  6. Counting to a specified numberin round, then add one to round
    By McG_84 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 09-10-2013, 04:20 PM
  7. How do I ROUND() round off decimals of a column dataset?
    By Højrup in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-12-2005, 07:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1