You are writing a formula in cell B2 that assigns a Discount…
You are writing a formula in cell B2 that assigns a Discount Code based on the product’s Region listed in cell A2. You want the formula to be easily copied down to the rest of the column, and your criteria table is located in cells D1:F3, where the regions are listed in column D and the corresponding codes are in column F. The rules are: If the Region (A2) is “North”, the code is “N-20”. If the Region (A2) is “South”, the code is “S-15”. Otherwise, the code is “General”. Which of the following nested IF statements, when entered into cell B2, will correctly determine the code and be suitable for copying down the column?