Figuring Rent in Excel

[mePenny]

I'm posting this question again because I do not see it in the line up.

I am looking for help to create an excel table where I can track my monthly
rent payments.

Rent: $815 pr month if payed by the 4th.
Late Fees: $50, one time charge, if the rent isn't payed by the 4th (this
would show up on the 5th).
Late Fees: $5 pr day charge for every day after the 5th if the rent is not
payed.

Any help would be truly appreciated.
I would like to prove to my landlord that I'm right!

mePenny

 

[Maarkr]

you're posting this question again because this is the Microsoft Access group
and not the microsoft Excel group.

 

[fredg]

I'm posting this question again because I do not see it in the line up.

I am looking for help to create an excel table where I can track my monthly
rent payments.

Rent: $815 pr month if payed by the 4th.
Late Fees: $50, one time charge, if the rent isn't payed by the 4th (this
would show up on the 5th).
Late Fees: $5 pr day charge for every day after the 5th if the rent is not
payed.

Any help would be truly appreciated.
I would like to prove to my landlord that I'm right!

mePenny

You have posted this question to the wrong newsgroup.
The access in this groups title refers to Microsoft Access, a database
program.
Please repost to the correct newsgroup for the Excel program you are
using.
I would suggest you include your Windows and Office version number in
your message. It might make a difference.

 

[Arvin Meyer MVP]

I'm posting this question again because I do not see it in the line up.

Make sure that all messages (not just unread messages) is selected

Any help would be truly appreciated.
I would like to prove to my landlord that I'm right!

In addition to what the others have said about the question being in the
wrong newsgroup, if you pay your rent on time, you will not need to think
about late fees.

That said in Excel, create a column with dates from 1 to 31. Add a column
with amounts:

815
0
0
0
50
5
5
5
....

Add a 3rd column with formulas:

=B1
=B1
=B1
=B1
=B1+ B5
=B1 + SUM(B5: B6)
=B1 + SUM(B5:B7)
=B1 + SUM(B5: B8)
=B1 + SUM(B5:B9)
....

 

[John W. Vinson]

I'm posting this question again because I do not see it in the line up.

Perhaps because you're looking in the wrong place. This newsgroup is not for
Excel, but for the database software Microsoft Access. The webpage can be
confusing and may have misled you.

I'd suggest looking for something distinctive, such as your "mePenny" name
<cute>, using Google Groups. To a lot of our frustration, the Microsoft
webpage is balky and not altogether reliable; their competitor Google does a
better job of searching. Let's see:

http://groups.google.com/groups/sea...t.public.*&as_usubject=&as_uauthors=&safe=off

Yep, finds your previous post in the Access group, with an answer from Jacek.