Vignesh Veerasamy
Member
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
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