Jean Stewart
New Member
Hello I have to update a price list by adding columns to show the price increase by % from 1 - 5%. I have added the percentage and done the =%+Current price. This is ok on 0.37 data but once the value increases to say 2.14 or 1260.00 it gives me an incorrect figure for example my sheet is currently telling me the 2.14 plus 5% is £2.19 where as it should be more like £2.25. Anyone any ideas what I'm doing wrong?