Adjust my formula to vary output based upon Y or N in cell

I have a formula that I have to figure pricing based upon a list less pricing structure. I need to add to the formula to look at a cell that will have Y/N. then if cell contains "Y" it will figure the discount price, if it contains "N" it will just give the result of the original list price.

I have attached a sample sheet with the basics.

Any help is apreciated.

Hello,

try

=(IF(E4="","",(VLOOKUP($E$4,B9:G8047,5,FALSE))))*IF(D6="Y",((100-$D$3)/100),1)

cheers,