Forum Discussion
Revenue structure
File Structure Reference Column A contains Client Names (e.g., A, B, etc.). Row 2 (starting Column B onward) contains month-end dates from Jan 2026 through Dec 2027. Columns B through the last mo...
Thanks NikolinoDE . Can you please make small extension to the formula? If there's no increment and/or termination date, then the value should return caluclating the base fee. For instance, as there is no termination date in range F6, the formula is returning 0 across every cell.
If your original formula was:
=IF(F6="", 0, B6 + (C6 * D6))
Modify it to:
=IF(OR(E6="", F6=""), B6, B6 + (C6 * D6))
emanate:
Base Fee is in cell B6
Increment Date is in cell E6
Termination Date is in cell F6
Original calculation (when dates exist) is: (Base Fee + (Increment Amount * Months))