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

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

gnaga

Well-known Member
Joined
Jul 9, 2002
Messages
723
Office Version
  1. 365
  2. 2016
  3. 2013
Platform
  1. Windows
A1 B1 C1 D1 E1 F1 G1 H1 I1 J1 K1 L1 M1 N1 O1 P1


Name Budget Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Spent Balance


Teacher - 1 200 20 10 10 15 20 20 10 10 0 0 =Sum(C1:N1) =B1-O1

I hope you understand this

GNaga
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,770
Messages
5,833,595
Members
430,221
Latest member
pgn29

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
Top