List Price $300 $300

First Trade Discount % 20% 18%

Second Trade Discount % 10% 12%

Third Trade Discount % 5% 7%

Net Decimal Equivalent

Single Trade Discount

Trade Discount ($)

I have to solve the Net Decimal Equivalent, Single Trade Discount, and Trade Discount using the Excel formula. Show the exact formula please

=(1 - 1st Trade Discount%)*(1 - 2nd Trade Discount%) * (1 - 3rd Trade Discount%)

=1-Net Decimal Equivalent