hello everyone i have a macro created where it will adjust the income and expenses a user inputs into my excel spreadsheet based on the number of months. It is utilized by a userform called "annualize" where the user will select which financial statement they would like to adjust the income and expenses. for example, if we don't have a full 12 month operating statement, i will adjust the income and expenses to the date of the current statement. so how the formula works by:
(sumifs formula)*month of financial statement / 12
pretty much my question, how can i return my calculations back to the original sumifs formula instead of "(sumifs formula)*month/12
return original equation.xlsb
Bookmarks