Search results

SirJB7... yes, that is exactly what I had come up with too. Consider yourself hugged for even taking the time to look at this and respond... Thanks Sir!!!

I got it... and it was with the help of the MIN formula within an IF function. Thank you all for your help, I appreciate it!

Faseeh, Between each of the "Rcvd" columns I have hidden columns that start with what would be column C as my beginning credit which is the total of the security deposit. Then after the Rcvd Arrears Column I have a subtotal that shows me the balance of the availble security less rcvd arrears...

I have never used dropbox before so I hope this link works. I still can't figure out to write a post that keeps my data in proper columns. https://www.dropbox.com/s/9up2w163t1vwerw/Move%20Out%20Report%20for%20help.xls Thank you for any help / suggestions you can provide me.

Thanks for the post and the idea. Unfortunately, that only solves half of my dilemma. Below is what I am trying to accomplish with some figures for some illustration: A B C D E F Sec Dep Arrears Damages RcvdArrears...

Hello, I work in a real estate management corporation. We receive deposits from tenants when they move into one of our units. When they move out, we calculate any CAM charges or damage fees. I am trying to prepare a report that shows if we have a $500 security deposit, and have $100 in utility...