If you want to take 20% off a product price in excel then follow the method: At first multiply discount% with original price then subtract it from the original price. Suppose the original price O, Discount Price DP. Now see the equation. DP= O - (20% x O)