Search results

I thought there was something like "offset" we could be build to do it for us.

I've got a couple formulas I am using in cells, but when I copy and past them in the next cells 2 columns greater because the place I copy pasted them are 2 columns further. Isn't there a way to alleviate that headache? =Detail!W6 (this in column E) =+'Disbursements YTD'!AG2976 (this is in...

This is what I have written so far, and it seems to be working! =IF(AND(Q$1+6>=$P3, $A$1+6>=$P3, $A$1>=Q$1), $H3, IF($P3<Q$1,0,IF($P3<=Q$1+6,$H3,0))) I just want to make sure my logic behind that makes sense, but it seems that I have made some really big progress if not, solved my own problem.

should I just start a new thread then?

Would it be easier to load another file? Here is a good example of 3 different scenarios. Invoice A due 5/30, falls in the 5/25 bucket and only the 5/25 bucket until the due date has passed (formula seems to work ok?) Invoice B due 5/7, falls in the 5/25 bucket and all previous buckets, but...

so think of it like this: on 5/25, you create a report using your aging and disbursements. your aging will reflect anything that still needs to be paid. so creating a table using this information that would reflect would require some formulas. I don't care when it's paid, I just care that is...

so the end result would be this: for supplier A: I would only expect to see an amount in the 5/25 column because it is due 5/30 and would not fall on 5/18 since it is driven on the Due Date, so the next time I would see it again was on 6/1 if it was not paid yet, since 5/30 is within the week...

having an issue trying to figure this out. basically, what I am wanting to write is something that looks at a few date fields, and determine the projected payments on that date, but being able to forecast it in a way that we aren't double dipping between scheduled payment and forecasted...

wow!! i like it!

Client A & B Both have customers they pay between COD (0 Days), N20, N30, N45, and N60. I'm trying to determine how to create a formula that would give me the best weighted average days paid for both parties.

Hi Narayan - I don't know any fancy jazz about VBA :D sorrie this may nt be useful to me! :D

Hi Faseeh!! =_) I like it, but somehow you built the function to pick the top ones, but the idea is match to the total amount the customer sends. so if it was 40,000 they paid, then you could have 9000+9000+9000+8000+5000 and that uses the 40,000 up.

Say I have a list of invoices, and the client says to use a maximum dollar amount to apply to their AR. I want to select the invoices that will reach the dollar amount to exhaust. Say I have 100 Invoices with various amounts, and the client sends in $50,000.00 and said apply it to whatever...