Forum Discussion
CINDY YATES
Jul 19, 2018Copper Contributor
RUNNING BALANCE NOT TO EXCEED $100,000 TRACKING OVERAGE AND CALCULATING A PAYMENT
SEE ATTACHMENTS
I need in Excel 2010 to:
1. Tracks MDF FUNDING EARNED less PRODUCT INVOICED less TRADESHOW-EVENTS expenses not to exceed $100,000.00 each month
2. When RUNNING BALANCE does not exceed $100,000.00 each month, MDF PAYMENT = MDF FUNDING EARNED
3. When RUNNING BALANCE exceeds $100,000.00, MDF PAYMENT = OVERAGE less MDF FUNDING EARNED or $0.00 if OVERAGE continues
Once the Running Balance reaches $100,000, the formulas I have in place no longer work. Any suggestions on how to change the formulas?
Thank you in advance for any help with this!!
No RepliesBe the first to reply