A very simple spreadsheet has two issues. 1. A cell will not calculate properly when others are updated. For some reason, a very simple calculation (=D29*D13) will not update when D13 is changed. 2. We wish to utilize a percent field in the calculation but cant work out how too. The field is set to 25% and we want to obtain a figure with that percentage as a discount. Currently we are using hard formulea such as 100*0.75 but this is not dynamic. These are very basic issues but need some help and explanation on how we can remediate.