• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Value between Range

Hi Gurus

Need a formula to validate a value in a cell lies between the range that is fixed.

For example

0-250 - Rs.2/-
251-500 - Rs.5/-

Cell value : Rs.234 ===> Range value : Rs.2/-
Cell value : Rs.721 ====> Range value : Rs.10/-

Thank you.

Vignesh V

Chief Ace

To be able people to help you, you might want to create a sample file and the expected results. That makes it easier for everyone what you are trying to do.

Chief Ace