Return a valuein one cell dependant on value of another

[davidcrawt]

OK, I'm not very good at Excel but I'm sure this will be easy for you guys to work out.

I need cell C5 to display a result dependant on the value of cell B5.

If B5 is between 1 and 23, I need 1.99 in cell C5

If B5 is between 24 and 47, I need 1.90 in cell C5

If B5 is between 48 and 143, I need 1.79 in cell C5

If B5 is 144 or above, I need 1.62 in cell C5

[TMS]

One way:

C5:

Please Login or Register  to view this content.

Regards, TMS

[newdoverman]

Here is another option:

Please Login or Register  to view this content.

Format for 2 decimal places.

[davidcrawt]

Thanks for that. I tried that but it always shows 1.62 in C5, no matter what figure I put in B5

[davidcrawt]

This one doesn't work either. It returns a value of #N/A

[TMS]

Then I'm guessing that B5 is formatted as text.

[newdoverman]

I'm guessing the same thing. I have both formulae in adjacent cells and they work flawlessly.

[davidcrawt]

Yes, that's it, it all works now. I did have the formatting as TEXT. Thank you so much you two guys for your suggestions.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[newdoverman]

Success is always sweet!