Find percentage and change it

[James Greenup]

I have several customers. Everyone has her own discount %. When I write a name, I want to find their discount %,calculate the price, round the price up, then to change the discount number. For example if Jane has 10%, the price is 960,after discount it will be 864, but as i will take only with 100$, i need to round it up,it will be 900, so it means that the clear % of discount war (960-900)/900=6,6%, and i want that 10% to be replaced by this 6,6%. And also don't want to get circular referencing error

 

[James Greenup]

Thanks i think i will do so, anyway if i round by 10s nothing will be rounded more than 0.5%,so rounding up the discount % will arrive the original rate. SO it's ok. Thanks again