Feb 24 2022 09:02 AM
Hi
I am trying to do set off of various positive amounts with 1 negative amount in Excel.
Is there any formula for this so that I can do this quickly.
Example -
Feb 24 2022 11:11 AM
Feb 24 2022 04:24 PM
I agree the -40 may be connected to 1 and 3 ( 10 and 30)
I take it @Samarth_sharma wants to have it automatically place a negative figure when the invoice is paid.
This can be done but a bit of messing around and different structure.
You can link a formula. I have a sheet that has payments and such but it looks like
=if(d4="Payment",E1,if(d4="Interest,D15,"")
D4 details
E1 payment value
D15 Interest calulation
Feb 24 2022 05:23 PM - edited Feb 24 2022 05:26 PM
I agree the -40 may be connected to 1 and 3 ( 10 and 30)
I take it @Samarth_sharma wants to have it automatically place a negative figure when the invoice is paid.
I acknowledge that something like that is possibly what is meant. But I like to have things spelled out more clearly before devoting time to resolving a question based on assumptions.
So please, @Samarth_sharma , help us help you by describing what those lines of particulars refer to, and how you expect the formula to recognize two of three lines of invoices that might add up to the 40 of a payment?
Once $40 has been paid, do you expect the spreadsheet also to mark (somehow) the invoices as paid? Or will you be doing that manually, line by line yourself?
What happens if there are other combinations that add up to the amount of payment? Are these invoices all FROM, and payments all TO, the same outside party? Etc.
The way you have written your example, it seems like a very inexact or imprecise kind of bookkeeping. Help us help you by making it more thorough.
Feb 24 2022 05:46 PM
I acknowledge that something like that is possibly what is meant. But I like to have things spelled out more clearly before devoting time to resolving a question based on assumptions.
I agree. it helps if there's a file with some sample info.