Subtracting amounts from a fixed amount

Closed
vssyam Posts 3 Registration date Saturday February 17, 2018 Status Member Last seen February 17, 2018 - Updated on Feb 17, 2018 at 04:39 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.
Please give me a replay.

3 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 17, 2018 at 05:31 AM
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 Posts 3 Registration date Saturday February 17, 2018 Status Member Last seen February 17, 2018
Updated on Feb 17, 2018 at 05:58 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.
Please revert me
Thanks
0
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 17, 2018 at 08:35 AM
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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Feb 17, 2018 at 07:42 AM
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
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.
Sorry to waste your time
if you can help me i am thankful to you
thanks for your help
0