The store gives a discount of 8% on the unit sale price if the item type is finished product, a discount of 6% on the unit sale price if the item type is semi-finished product, and a discount of 4% on the unit sale price if the item type is raw material. Determine the Discount % for each item depending on the respective Item Type. You should use IF statement and absolute reference to accomplish this task.
How do I make the IF Nested function for this in excel. Right now the formula I have is =IF(C6:C53=Raw Material, "4%", IF(C6:C53=Semi Finished Product, "6%", IF(C6:C53=Finished Product, "8%"))) AND this is not working correclt.