Value without discount

[The Animal]

Hey Crew
I have a spreadsheet that is used to generate quotations, some have discounts some do not. Below is worksheet columns
No Description Unit Unit Selling Unit Less 5%
1.00 Carrot-Large 0.00 $18.00 $17.10

The unit less 5% column uses a common cell (N1) to calculate the 5% (.95) discount =D6*$N$1.
I need the Unit less 5% cell (E6) to use the same value as the unit selling cell (D6) if the particular quote does not have a discount. I do not want cell E6 to have a zero value as I have at the moment because I have the cell linked to other worksheets and need the Unit selling price a mirror of Unit Selling only if a discount is not applied
Thanks Stephen

[darkyam]

Sounds like you need another cell to tell Excel whether a discount is to be applied or not. Have one cell, call it N2 for this example, have a Yes or No in it for applying the discount. Your discount price can then be =D6*IF($N$2="Yes",$N$1,1)