Excel formula help

Hi,

I am building an excel spreadsheet and I need help putting together a formula that allows me to choose a $ amount based on a % range. let me explain:

I need the formula to look at a cell, let say E37, and based on the % number  in that cell, to determine the associated $ amount:

- if E37is LESS than 5% (cell D46), then $ amount should be the amount located in cell G46

- if E37 is BETWEEN 5% and 9.99% (cell D47), then the $ amount should be the number located in cell G47

- if E37 is BETWEEN 10% and 15% (cell D48), then the $ amount should be the number located in cell G48

- if E37 is MORE than 15% (cell D49), then the $ amount should be the number located in cell G49.

Does anyone know how to write such a formula? I tried using a multiple 'IF" formula but I cant get it to work...

thanks