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