=IF setup

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. 

By: Linda

Leave a Reply

Your email address will not be published. Required fields are marked *