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
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Feb 17, 2018 at 08:35 AM
Related:
- Subtracting amounts from a fixed amount
- How do you convert amounts into words - Guide
- This view in microsoft word opens the document to a full screen. this view is great for reading large amounts of text or simply reviewing your work. - Guide
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
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
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
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
Feb 17, 2018 at 08:35 AM
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
"...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
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
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
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
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
Updated on Feb 17, 2018 at 05:58 AM
=H4--$F$3-G4 but the result is 0.
Please revert me
Thanks