Subtracting amounts from a fixed amount
Closed
vssyam
Posts
3
Registration date
Saturday 17 February 2018
Status
Member
Last seen
17 February 2018
-
17 Feb 2018 à 04:33
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Feb 2018 à 08:35
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 17 Feb 2018 à 08:35
Related:
- Subtract a column in excel
- Excel column number - Guide
- Excel mod apk for pc - Download - Spreadsheets
- How to delete a column in word - Guide
- Arrow keys not working in excel - Guide
- Vat calculation excel - Guide
3 responses
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Feb 2018 à 05:31
17 Feb 2018 à 05:31
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
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
Mazzaropi
Posts
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Feb 2018 à 08:35
17 Feb 2018 à 08:35
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
"...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
1983
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
17 Feb 2018 à 07:42
17 Feb 2018 à 07:42
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
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 17 February 2018
Status
Member
Last seen
17 February 2018
17 Feb 2018 à 08:06
17 Feb 2018 à 08:06
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
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
17 Feb 2018 à 05:52
=H4--$F$3-G4 but the result is 0.
Please revert me
Thanks