PDA

View Full Version : Need Help....Formula


vishwakarma
03-01-2011, 03:13 AM
Hi Guys,

please find the attached file for the query...


Thanks..


Manoj
Bob Phillips
03-01-2011, 03:19 AM
Try

=IF(AND(E2>=--LEFT(A2,FIND("-",A2)-1),E2<=--MID(A2,FIND("-",A2)+1,9)),B2,"")
vishwakarma
03-01-2011, 03:48 AM
Thanks for the reply xld... but it is not giving me the desired result ..


Manoj
Bob Phillips
03-01-2011, 04:40 AM
Give me an example where it doesn't because it seemed fine to me.
shrivallabha
03-01-2011, 07:56 AM
A very gross method as compared to Bob's method as it considers 5 figured numbers:

=IF(E2>ABS(LEFT(A2,5)),IF(E2<ABS(RIGHT(A2,5)),B2,"Outside Range"),"Outside Range")
mdmackillop
03-01-2011, 01:18 PM
The dash in A7 is different from the normal "-" sign, causing the formula to fail.