Subtracting amounts from a fixed amount [Closed]

Report
Posts
3
Registration date
Saturday February 17, 2018
Status
Member
Last seen
February 17, 2018
-
Mazzaropi
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
-
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.
Please give me a replay.

3 replies

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4001 users have said thank you to us this month

vssyam
Posts
3
Registration date
Saturday February 17, 2018
Status
Member
Last seen
February 17, 2018

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.
Please revert me
Thanks
Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 4001 users have said thank you to us this month

Posts
1833
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 30, 2018
135
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
Posts
3
Registration date
Saturday February 17, 2018
Status
Member
Last seen
February 17, 2018

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.
Sorry to waste your time
if you can help me i am thankful to you
thanks for your help