Excel Spreadsheet - Coding(?)/Formula Assistance

Discussion in 'Microsoft Office' started by Cripple.Zero, Dec 21, 2017.

  1. Cripple.Zero

    Cripple.Zero MDL Novice

    Jun 7, 2016
    My apologies if I put this in the wrong forum....

    I have built a checkbook register spreadsheet that rounds my totals of debits or credits up or down depending on the transaction. Mostly it just rounds to the nearest $1 so I can sort of buffer "extra" cash. Ultimately, it works fine. However, when I was doing it by hand in a regular check register, on paycheck day I would round that check to the nearest $5 or $10 depending on how much I needed to buffer (or save).

    I need to figure out how to keep all transactions as the normal $1 estimations, but when I deposit something like a paycheck or large sum of money, to only estimate $10 for those transactions.
  2. 123PMS

    123PMS MDL Novice

    Dec 30, 2017
    you can round as many places as you like. Round to $10 is round(cell,-2)