Excel formula for range and value

[Wizza_Teo]

I need to write a formula in Excel, when the Monthly Total Wage is $1000 or below, the value appearing will be $3, when the Monthly Total Wage is more than $1000 to $2000, the value appearing will be $4.50 and so on, as seen in the photo below. How may I formulate this in one formula?

[#2]

@Wizza_Teo Create a lookup table with the lower boundaries for each bracket. Then LOOKUP can find the correct value. See attached.