A Retailer Tracks List Prices and Discounts in an Excel

A retailer tracks list prices and discounts in an Excel spreadsheet so owners can analyze how different sales will affect the company's bottom line. One item in Cell B4 has a list price of $172.89. Varying rates for discount 1 and discount 2 can be entered into Cells B5 and B6. Which formula should be entered into Cell B7 to calculate the net-price equivalent?

A) =B4*B5*B6
B) =B4*(1-B5) *(1-B6)
C) =1-(B5+B6)
D) =(1-B5) *(1-B6)