May 02 2018 12:21 AM
Hi guys
I need help with a formula to dynamically re-calculate my target based on the actual input.
I need a dynamic formula that will re calculate everytime the user enters the actual amount for the month. I have visited this page Calculate Monthly Goal to reach target on stackoverflow and it does exactly what I want but I want it to be dynamic based on the percentage inputs.
May 02 2018 07:24 AM
Can you provide a non-sensitive sample file so that we can better understand your data representation, data structure and the existing formulas? It will make it easier for someone in the community to assist you with more detail.
May 02 2018 07:31 AM
May 02 2018 11:42 AM
What about if O4 = SUM(C14:N14)-SUM(C13:N13)?
Maybe I'm missing something?