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
