If cell value is between XX and XL, display B

[MX5BOI]

I am tring to write a formula but having no luck
What I want it to do is:
If B12 is between 0 and 12, display $145 or
If B12 is between 13 and 45, display $150 or
If B12 is between 46 and 90, display $155 or
If B12 is between 91 and 145, display $165 or
If B12 is between 146 and 223, display $175

NB - The value of Cell B12 will always be between 0 and 233 (so no other variable are required)

Can anyone help me?

 

[halebopp_x]

What software do you want to use?

 

[MX5BOI]

This is the " Microsoft Excel Worksheet Functions" forum. So I will be using Microsoft Excel

 

[halebopp_x]

Maybe it can help you,

=IF(B12<13,145,IF(B12<46,150,IF(B12<91,155,IF(B12<146,165,IF(B12<224,175)))))

 

[MX5BOI]

OMG. You are a genius Thank you so much. It was doing my head in.
Thank you again