Creating a drop down list to change decimal value in another cell

Hi guru's :o)

I want to create a drop down list (with text: GBps, MBps, KBps etc) to change corresponding decimal value in another cell to update the entire spreadsheet with the new unit of measurement.

I have attached an excerpt of the spreadsheet. Hopefully it will give you an idea of what i want to do.

Thanks :o)