Hi Everyone!
I am new here but would love some help!
The "Target ARR" number in L14 is my target number that I need the "Total ARR" in L12 to equal to based on the calculations from the items right above it. The discount for all products (A-F) would need to be the same for all products. The total from that plus the "Entitlement" number is B11 need to equal the Total ARR.
Is there a way to sort of reverse engineer the formula if you have the starting number to calculate the discount needed? If it cant include the Entitlements number in B12 that isn't a big deal. That number is usually static anyway.
Any help would be greatly appreciated. I have been fumbling around with this for weeks. The file should be attached.
Bookmarks