If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)

Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

Excel rent book

foley_b · 2013-11-06 22:37:37

Hi, I'm trying to create a rent book in excel showing date,rent due including arrears,rent paid and arrears. Any ideas would be great,thank you

Options

06-11-2013 11:37pm

#1

foley_b

Registered Users Posts: 43 ✭

Join Date: October 2008

Posts: 30

Hi, I'm trying to create a rent book in excel showing date,rent due including arrears,rent paid and arrears. Any ideas would be great,thank you

0

Comments

Options
#2 07-11-2013 10:44am
FSL

Registered Users Posts: 1,456 ✭✭✭

Join Date: February 2006

Posts: 1419

Create a schematic of what you want to achieve, then expand it to show all the logic. Make sure there are no closed loops or missing branches. You will then be able to apply it to your spreadsheet.

0