Excel "IF" Statement:

Two columns are actual and predicted P/E ratio.

b) In order to better serve your clients you decide to offer more flexible recommendations by expanding your stock classification categories. You will have three categories - buy, hold or sell, based on the following criteria:

(i) If the actual P/E ratio is less than the predicted P/E ratio, the stock is classified as buy

(ii) If the actual P/E ratio is greater than the predicted P/E ratio, and the difference is less than 10% of the actual P/E ratio, the stock is classified as a hold

(iii) If the actual P/E ratio is greater than the predicted P/E ratio, and the difference