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.
Bookmarks