MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Help with a formula


Posted by Mike on July 17, 2001 9:54 AM

Need a True/False return if the last 3 digits of a number is greater than 299 and less than 400. IE 10150301 should return "True".
Thank you in advance for any help.


Posted by Barrie Davidson on July 17, 2001 9:59 AM

Assuming your number is in cell A1 (and that it is a number and not text), then this formula will provide your true/false return.

=AND(A1-ROUND(A1,-3)>299,A1-ROUND(A1,-3)<400)

Regards,
Barrie