Hi there
I have input three formulas in columns F, G, H of the attached workbook named 'Example1', but would like to include them all in just the one formula/column. Possible?
For completeness, what I am trying to achieve with the result is, if client pays within 35 days they receive 40% share of our commission (column E). More than 35 days they receive 30% share of our commission.
In calculating the 35 days, it is the Client Paid Date (column A) from the Eff. date (column C), UNLESS the Invoice Date (column B) is greater than the Eff. Date, then it will be Client Paid Date from the Invoice Date.
Hopefully makes sense, and thanks in advance.
Bookmarks