# subtracting/newbie help

#### ninip

##### New Member
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.

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.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
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

Sorry I don't understand this
I am totally new to Excel

Replies
1
Views
449
Replies
1
Views
553
Replies
4
Views
273
Replies
2
Views
422
Replies
9
Views
352

1,218,625
Messages
6,143,576
Members
450,493
Latest member
Woejeber

### 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.

### Which adblocker are you using?

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

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