margil patel
New Member
dear sir, please see this attachment.
how to subtract amount
- Thread starter margil patel
- Start date
David Evans
Active Member
In your IF statement, you are not providing a decision path for when the Received Amount is LESS than the Outstanding Balance on a Bill - That is why you are getting the FALSE in Option 2.
Are you converting a legacy paper system to Excel? If so, perhaps you can dispense with quite a few steps in your process. This is where the confusion arises.
Are you converting a legacy paper system to Excel? If so, perhaps you can dispense with quite a few steps in your process. This is where the confusion arises.
Last edited:
margil patel
New Member
NARAYANK991
Excel Ninja
Hi ,
I am not able to understand this formula :
=IF(H7>G10,(G10-H7))
H7 is the received amount ; G10 is the first outstanding amount.
What the formula is doing is if the received amount is more than the outstanding amount , it is subtracting the received amount from the outstanding amount. Why ?
If you can explain in clear terms where you want formulae inserted , and what should be the results these formulae should display in their cells , we can suggest the appropriate formulae.
The columns I and M may not be necessary , and it is better we do not concentrate on your formulae in these two columns.
Narayan
I am not able to understand this formula :
=IF(H7>G10,(G10-H7))
H7 is the received amount ; G10 is the first outstanding amount.
What the formula is doing is if the received amount is more than the outstanding amount , it is subtracting the received amount from the outstanding amount. Why ?
If you can explain in clear terms where you want formulae inserted , and what should be the results these formulae should display in their cells , we can suggest the appropriate formulae.
The columns I and M may not be necessary , and it is better we do not concentrate on your formulae in these two columns.
Narayan
margil patel
New Member
NARAYANK991
Excel Ninja
Hi ,
You mention :
Narayan
You mention :
How do we know to which bills the received amount is to be allocated ?
Narayan
margil patel
New Member
NARAYANK991
Excel Ninja
Hi ,
Questions seem to be cropping up with every post.
If the received amount has an exact match , we can write a formula to allocate the received amount to a specific bill , but what about the amount you showed earlier 100,000 ?
This can be allocated to multiple bills ; how will those allocations be decided ?
Narayan
Questions seem to be cropping up with every post.
If the received amount has an exact match , we can write a formula to allocate the received amount to a specific bill , but what about the amount you showed earlier 100,000 ?
This can be allocated to multiple bills ; how will those allocations be decided ?
Narayan
David Evans
Active Member
This problem needs to be re-thought from the perspective of an Excel Process, rather than "can you find me an Excel Solution?".
Yes, it's possible to create an Excel solution - I've seen the Ninjas here produce some amazing formulae, however, they require a very thorough and advanced knowledge of Excel. If anything goes awry with your worksheet, it will require the intervention of a Ninja to fix it, I fear.
There are simpler, more logical ways of laying out this challenge and I suggest you consider making that your goal. The current process is too complicated to explain - therein is the clue.
Yes, it's possible to create an Excel solution - I've seen the Ninjas here produce some amazing formulae, however, they require a very thorough and advanced knowledge of Excel. If anything goes awry with your worksheet, it will require the intervention of a Ninja to fix it, I fear.
There are simpler, more logical ways of laying out this challenge and I suggest you consider making that your goal. The current process is too complicated to explain - therein is the clue.