Excel 2010, Win 7
I am trying to return actual value in E25 if the result is between 5% and -5%. Otherwise, if greater than 5%, then 5%; if less than -5%, then -5%.
I have tried various books and googled, but I am not an Excel pro. I can return cap of 5% if result is greater, but when the result is -10%, it returns -10% and not -5%. Appreciate any assistance, thank you so much.