Sales flex formula

[vBakerr]

Hi,

I am having trouble trying to work out a formula for flexing sales and labour, basically for every £500 up/down against my predicted forecast I am allowed to spend/need to save 9 hours. I am not well versed in how to use the more intricate details of Excel and therefore have come stuck in this situation. I also need it to adjust to sales of less/more than £500, E.g £350 would be 6.3 hours hope that makes sense. If possible could the formula also work of a pre-existing cell? so the final would basically take the difference in my sales against forecast and then work our how many hours I would need to save or I could spend as a number rather than a currency.

If I haven't explained that well enough or some clarification is needed please let me know.

Thanks

[GeoffW283]

Here is as much as I can glean from your request
The formula in D2 copied down to D5 is:
=(C2-B2)*9/500

If this is not what you are looking for then please provide a sample workbook in accordance with the instructions in the yellow bar at the top of this thread.