• 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

    Hui...

  • 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/-
501-1000-Rs.10/-
>1000-Rs.25/-


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

Thank you.

Vignesh V
 
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.

Cheers!!
Chief Ace
 
Back
Top