Sales Report A: Disc 10% B: 15% C: 20% Determine the formula to calculate sales discount depend on item =IF(C2=”A”,0.1,IF(C2=”B”,0.15,0.2)) Fomula IF is needed more than one, IF ONLY the condition have more than two values Checking the string/text value need to put inside quote, while checking the number value don’t If the formula has