1. Make a formula that uses an IF function andstructured references to assign a priority valueto each customer. (Tip: You will need to use anAND function in this formula.)
a.The If function should check if acustomer has a Tenure field value greaterthan or equal to 5 years AND 2016sales field value greater than or equal to150000.
b.If the customer meets both thosecriteria, the function should return the valueHigh.
c.If the customer does not meet boththose criteria, the function should return the valueLow.
2. Make a formula that uses a nested IFfunction and structured references tocalculate the discount percentage:
a.If the value in DiscountY/N column is equal to N, the Discountcolumn value should be 0.
b.If the value in theDiscount Y/N column is equal to Y, the formulashould check if the value in the Tenure (Yrs)column is less than 5.
c.If the value in Tenure(Yrs) column is less than 5, the Discountcolumn value should be 0.07
d.Otherwise, the value ofDiscount column should be0.1.
(Note: The Discount column isformatted with the Percentage Number format, sothe values returned by the nested IF function willappear as 0%, 7%, or 10%.)
1. Make a formula that uses an IF function andstructured references to assign a priority valueto each customer. (Tip: You will need to use anAND function in this formula.)
a.The If function should check if acustomer has a Tenure field value greaterthan or equal to 5 years AND 2016sales field value greater than or equal to150000.
b.If the customer meets both thosecriteria, the function should return the valueHigh.
c.If the customer does not meet boththose criteria, the function should return the valueLow.
2. Make a formula that uses a nested IFfunction and structured references tocalculate the discount percentage:
a.If the value in DiscountY/N column is equal to N, the Discountcolumn value should be 0.
b.If the value in theDiscount Y/N column is equal to Y, the formulashould check if the value in the Tenure (Yrs)column is less than 5.
c.If the value in Tenure(Yrs) column is less than 5, the Discountcolumn value should be 0.07
d.Otherwise, the value ofDiscount column should be0.1.
(Note: The Discount column isformatted with the Percentage Number format, sothe values returned by the nested IF function willappear as 0%, 7%, or 10%.)