James Greenup
New Member
- Joined
- Jul 14, 2014
- Messages
- 16
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