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.
Try this formula:
=ROUNDUP(A1,0)-A1
Thank you so much!
cmumph: you say several times "round to the nearest whole dollar". The nearest whole dollar to $326.35 is $326. The example given however implies that a round up is required. Which is it? If the former then the answer would be Phuocam's solution but without the "UP".
The correct way to mark a thread as solved (I've done it for you this time): please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks