EXCEL Multiple Ranges - need different answers for each range

EXCEL Multiple Ranges - need different answers for each range

I have spent a few hours working out how to do this which is why im
posting it here now... If you want to return different values in a cell
based on which range the value entered in another cell comes under then I
have worked out how to do it!! (bear in mind that this is specific to my
spreadsheet and was for calculating prices i.e. 0.99 = £0.99)
For example:
IF G2 is ABOVE "0" BUT BELOW "1" THEN display "0.1"
IF G2 is ABOVE "0.99" BUT BELOW "5" THEN display "0.15"
IF G2 is ABOVE "4.99" BUT BELOW "15" THEN display "0.2"
IF G2 is ABOVE "14.99" BUT BELOW "30" THEN display "0.5"
IF G2 is ABOVE "29.99" BUT BELOW "100" THEN display "0.1"
IF G2 is ABOVE "99.99" THEN display "1.30"
So IF G2 was "£18.75" then the cell that this formula is entered in would
display "£0.50" based on the value's above.
You will see the above formula contained within the answer to this
question below......