AllCare offers a 3.2% (ACDiscount) discount on items when more than three units are ordered at one time. In column F, use a nested IF and AND formula and the named ranges (Supplier, ACDiscount, UnitPrice, NumToOrder) to calculate the discount for each of the supplies listed. If no discount is given, place a zero (0). Format the numbers in the column to display two digits past the decimal point. Note: Use all lowercase letters when typing the formula.
Solved by F. A. in 23 mins