Forum Discussion

CINDY YATES's avatar
CINDY YATES
Copper Contributor
Jul 19, 2018

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