Problems with setting up a billing budjet

  • Thread starter Thread starter JoeStL
  • Start date Start date
J

JoeStL

Wow, talk about a useful program. Where have I been all these years?
Oh, yeah! Happy Turkey Day!

This is a basic question for a basic form. I can't seem to navigate
through excel (actually using Open Office but it's nearly the same) to
find a proper solution for my problem. I've attached a working .xls
file so you can see what I'm doing wrong.

I've created a monthly billing statement to gather money from my
roommates to pay our bills. The top portion is set up on a monthly
basis for the different bill types. It calculates the amount owed from
all the bills.

Now I want it to divide that amount into 3 parts so it will show how
much is owed individually. If anyone could help me out I would really
appreciate it.

Thank You,

Joe From St. Louis

Image of excel (open office) form
[image: http://www.joekiske.com/foo/excelhelp.jpg]

http://www.joekiske.com/foo/monthly_bills.ods

When downloading you may need to change the ".ods" into an ".xls"
extention. Only if it doesn't open in excel... Though it should.
 
Hi Joe

In cell B14
=$B$10/3
copy down through B11:B12
Copy cells B10:B12 across through C10:M10

Regards

Roger Govier
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top