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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.