# Subtracting amounts from a fixed amount

vssyam 3 Posts Saturday February 17, 2018Registration date February 17, 2018 Last seen - Feb 17, 2018 at 04:33 AM - Latest reply: Mazzaropi 1792 Posts Monday August 16, 2010Registration dateContributorStatus March 18, 2018 Last seen - Feb 17, 2018 at 08:35 AM
Hello,

I need a equation for subtracting amounts that i entered from a fixed amount. Here is my screen shots.

I enter 10000 in row 1 column A Then i enter 500 in row 2 column B That time my subtracted amount will be show in row 2 column C(Ans:9500).Then again i enter 200 in row 3 column B the answer 9800 will show in row 3 column c.It will continue.Every time i enter a amount it will subtract from 10000 and the answer will be show in next column.
See more

## 5 replies

Mazzaropi 1792 Posts Monday August 16, 2010Registration dateContributorStatus March 18, 2018 Last seen -
+1
1
vssyam, Good morning.

Using your image as model, try to use:

F3 ---> =B2 ---> 10000

H4 --> =\$F\$3 - G4
Copy it down in H column.

Please, tell us if it's what you want.

I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
vssyam 3 Posts Saturday February 17, 2018Registration date February 17, 2018 Last seen - Feb 17, 2018 at 05:52 AM
Is there have any function before this equation. like IF or something like that because when i copy paste the equation it shown as just a text in that field no change had happen.i used the code as
=H4--\$F\$3-G4 but the result is 0.
Thanks
Respond to Mazzaropi
Mazzaropi 1792 Posts Monday August 16, 2010Registration dateContributorStatus March 18, 2018 Last seen -
+1
vssyam,

"...Can we do like this by any equation. ..."
Yes, off course.

Formula at H4 cell stay the same.

You only need change the formula at H5

H5 --> =IF(G5="", "", H4-G5)
Copy it down as necessary.

Is that what you want?

I hope it helps.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
Respond to Mazzaropi
Mazzaropi 1792 Posts Monday August 16, 2010Registration dateContributorStatus March 18, 2018 Last seen -
0
1
vssyam,

The formula is =\$F\$3-G4 that you must enter at H4 cell.

I reproduced your example and applied the formula as I indicated.
Also increased the formula for when there is nothing in the cell next door.

https://www.sendspace.com/file/37nr2n

It was that what you wanted?
I hope I have helped.
--
Belo Horizonte, MG - Brasil.
Marcílio Lobão
vssyam 3 Posts Saturday February 17, 2018Registration date February 17, 2018 Last seen - Feb 17, 2018 at 08:06 AM
Now its working Thanks for your help. I need one more help in the same work i need
First we enter 10000 in F3 then we enter 500 in G4 that time F3-G4(1000-500)=9500 will show in H4.
Then i enter 200 in G5 at the time H5 show (9500-200=9300)that means H4-G5.Then i again
enter 400 in G6 then H6 show(9300-400=8900)
Can we do like this by any equation.