vssyam3
Posts Saturday February 17, 2018Registration date
February 17, 2018
Last seen

Feb 17, 2018 at 04:33 AM  Latest reply: Mazzaropi1834
Posts Monday August 16, 2010Registration dateContributorStatus
May 30, 2018
Last seen
 Feb 17, 2018 at 08:35 AM
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.
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$3G4 but the result is 0.
Please revert me
Thanks
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 F3G4(1000500)=9500 will show in H4.
Then i enter 200 in G5 at the time H5 show (9500200=9300)that means H4G5.Then i again
enter 400 in G6 then H6 show(9300400=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
=H4$F$3G4 but the result is 0.
Please revert me
Thanks