I have a spreadsheet in Excel 2010 that contains Column A and Column B. Column A is Percentage Decrease. Column B is Percentage increase. I need a column C to return the value "Increase," "Decrease" or "No change" when comparing the two columns.
Example:
A-Percentage Decrease B Percentage Increase C Net Impact
10% 20% Increase
40% 30% Decrease
50% 50% No change
What formula would I insert in Column C to return these values?
Currently, I have the formula: =IF(A>B, "Decrease," "Increase")
This returns correct "Increase" and "Decrease" values, but of course does not return "No change" values. (It returns A = B as "Decrease).
Thanks for your help!
Bookmarks