+ Reply to Thread
Results 1 to 5 of 5

Bank Deposit Formula

  1. #1
    Registered User
    Join Date
    12-15-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2007
    Posts
    3

    Bank Deposit Formula

    I recently downloaded a printable bank deposit which would be a great help since I deposit quite a few checks and this eliminates handwriting them. This formula is a little too complicated and I was wondering is someone can help me to translate it. The only problem I have with it is the fact that this only adds up the checks, if there is cash included in the deposit, it doesn't count it in the total.

    Attached is the deposit slip.

    =IF(LEN(AT3)<2,"$"&AT6&".0"&AT3,"$"&AT6&"."&AT3)

    Any help is appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Bank Deposit Formula

    bank-deposit-slip(1).xlsx

    Is this what you wanted? It also fills inteh number of items too
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    12-15-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2007
    Posts
    3

    Re: Bank Deposit Formula

    Thanks so much for your answer. The one thing I forgot to ask is how do you convert the cents into 00 when the dollar amount is a whole number?

    Thank you.

  4. #4
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    2,082

    Re: Bank Deposit Formula

    If you're asking how to display zero cents as 00 or 1 cent as 01 then simply format the cells (U3 to AT3) as 00.

    The easiest way to do this is to highlight that range, right click, format then choose custom and type in 00

    Did I understand your question correctly? Is this what you wanted?

  5. #5
    Registered User
    Join Date
    12-25-2016
    Location
    Valparaiso
    MS-Off Ver
    rgarrison
    Posts
    1

    Re: Bank Deposit Formula

    I have the same issue with this one, it does not add the coin or cents downward.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Excel 2007 : Find bank balance in bank statement
    By Baldev Kumar in forum Excel General
    Replies: 5
    Last Post: 07-05-2012, 02:58 PM
  2. Need formula to figure compound interest of a deposit for a year
    By Don in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-06-2005, 06:05 PM
  3. Need formula to figure compound interest of a deposit for a year
    By Usedtobesmart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. Need formula to figure compound interest of a deposit for a year
    By Don in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 07:05 AM
  5. [SOLVED] Need formula to figure compound interest of a deposit for a year
    By Usedtobesmart in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

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