percentage transfer

[ROBERTORIENTA]

hi i am currently working on a quotation sheet that is basically divided iin two sheet where on sheet one i have th client cop and sheet 2 i have our copy. the reason behind this is that i dont want the client to see the workings of the quote. i am having a problem with the percentage of discount. I need to be able to insert a percentage of discount on my copy and the result will be calculated in the client copy . can somone please help with this as it is resulting as #value i am also uploading a copy of the worksheet.

Thanks