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

Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.

https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

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

06-11-2013 11:37PM

#1

foley_b

Registered Users, Registered Users 2 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

#2 07-11-2013 10:44AM

FSL

Registered Users, Registered Users 2 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