Hello everyone, I am trying to produce a spreadsheet which can predict sales based upon the following idea that: For every 10 pence rise a products price, the average monthly sales decreases by 20.
I am fairly new to Excel and was wondering if anyone could guide me on what to do?
Many thanks.