subtracting/newbie help

ninip

New Member
Joined
Sep 16, 2002
Messages
4
Hi everyone
Could someone please explain to me step by step, I am a newbie to Excel at work.
This is what I need to know how to do.

I have a spreadsheet with the headings across the top:
Name Budget Jan. Feb. Mar. to Dec. Spent Balance

5 Rows with teachers names

What I need is if they start with a budget of $200.00, the balance column needs to say $200.00.
Then every month I put in what they spent and I need the balance column to change automatically.
I hope this is clear and not too confusing.
But I have no idea how to do this so that the balance and the spent column change automatically. So basically subtracting not adding.
Please someone help
Thanks so much in advance
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Hi ninip,

... welcome to the board.

There are ways to do what you are asking, but it would be MUCH easier if you would just keep a BEGINNING BALANCE and a CURRENT BALANCE field. BEGINNING BALANCE (in your example) would always remain at the $200, but the CURRENT BALANCE would reflect the BEGINNING BALANCE less the monthly activity.

Do you have the freedom to change the format?
 
Upvote 0
Thankyou for the welcome.
Yes the spreadsheet is my dept. But the clerk before me (she has left company) set it up this way and the teachers like it, so I wanted to continue. I used it last year and it worked fine. But now I need to change teachers names this year and amounts on a new spreadsheet and can't figure out how to get the automatic change of the SPENT & BALANCE COLUMNS
Thanks in advance
 
Upvote 0
Then you are talking a whole different animal. The first thing you need to do is determine where the formula are, and what they are (and do). The following instructions are from a website called spreadsheetstyle.com, it will explain how to change the color of the cells with formulas so you can find them without checking each one:<pre>
4. The Glowing Formula Rule. Format constants and formulas differently,
so your reader does not need to move the cursor to hunt for formulas.
A pleasant approach is to format formulas with a very light gray.
Unfortunately, Excel does not put the nicest gray on its default palette.


First select Tools, Options, Colors.

Select one of the ugly-colored chart fills, then click Modify.

In the Standard colors, choose the very lightest gray that is not white,
then click OK, and OK again.

Now use Edit, Go To, Special, and tick Formulas, then click OK.

At this point, all the formulas in the sheet (not in the whole
workbook, just this sheet) are selected.

Select Format, Cells, Border, Color Gray-40%, then Outline and Inside.

Select Patterns, then your new very light gray. Click OK.

Type the word "Formula" into a cell at the top, and format it
like the formulas.

Now all your formulas are in light gray and will be easy to find.
Your reader will see immediately which cells are formulas and which are constants.</pre>



_________________
JRN

Excel 2000; Windows 2000
This message was edited by Jim North on 2002-09-17 08:06
 
Upvote 0

Forum statistics

Threads
1,223,430
Messages
6,172,053
Members
452,444
Latest member
ShaImran193

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top