I need formula help for the below column. What I want is a formula that will tell me overall for the column if the majority of numbers have increased or decreased for the month.
% Increase or Decrease from Prior MTD (header)
100.00%
-25.00%
-50.00%
0.00%
-71.43%
100.00%
125.00%
-33.33%
0.00%
-75.00%
0.00%
100.00%
Decreased (this is where I want the formula). I want it to say either "increased" or "decreased" depending on the whether the majority of percentages are negative or positive.
Thank you in advance for help
Bookmarks