If cell value is between XX and XL, display B

M

MX5BOI

Joined
Jul 17, 2011
Messages
3
Reaction score
0
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

setting multiple conditions in one cell 2
IF & OR functions 5
IF AND VLOOKUP formula needed 1
Can I do a conditional formatting on a cell that is not the same w 4
If And statements -- HELP! 8
Comparing Text to Several Cells 4
Value of a cell in a range if color is yellow 3
Calculating the Average for non consecutive cells using custom for 2

Back
Top