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 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 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.
Please give me a replay.
See more 

Your reply

5 replies

Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 17, 2018 at 05:31 AM
1
Thank you
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1809 users this month

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.
Please revert me
Thanks
Respond to Mazzaropi
Best answer
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 17, 2018 at 08:35 AM
1
Thank you
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

Thank you, Mazzaropi 1

Something to say? Add comment

CCM has helped 1809 users this month

Respond to Mazzaropi
Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - Feb 17, 2018 at 07:42 AM
0
Thank you
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.
Sorry to waste your time
if you can help me i am thankful to you
thanks for your help
Respond to Mazzaropi