Use our database to look up Samsung IMEI numbers. Free Samsung IMEI checker - verify phone model, carrier and purchase details. You only need to provide the IMEI number and you will receive all information about, the country. The usage of the text format for the TEXT function "0 0\/1" what this does is interpret the numbers as fractions ! Since the denominator is 1, it does not matter, but look at what it does enter 1 2/1 ( or =1 2/1 ) in a cell and see what Excel displays.Ĥ.Free warranty and other features check for all Samsung models. The usage what this does is generate the numbers 1 through 16 ! It does not matter that they are generated in the form of a matrix, since the MID function does not mind.ģ. Adding the 0 - it does nothing to the calculations, but it is absolutely essential for the technique to work.Ģ. The formula is almost a work of art ! There are at least 3 or 4 strokes of genius there :ġ. If this is the case, then other formulas ending 10-RIGHT(A1) could be changed to MOD(-RIGHT(A1),10) or adapted to something like =MOD(.+RIGHT(A1),10)=0. (I have a hunch it may be to do with European settings because of the semicolon used as argument separator in the question.)Īdditionally, I think there's a tweak to be made to the problem specification since using "10-mod(sum 10)" for the checksum you can't match a sum that ends with 0. Regional settings changing the meaning of any of the following characters, hidden characters in cells such as non-breaking space, html translations when copying, etc. There are also numerous other reasons why formulas might appear to give different values for different users. I haven't checked that thoroughly and there may well be an error on my part somewhere.
Two top most notable members on this site suggest at least the first one is working for them. You sure that's what you get with your settings? I'm getting the opposite boolean values for your two examples with both formulas and find they agree with other formulas.
Looking forward to be amazed by any solution you may come up to. Write a single formula that, given an IMEI, would check the last digit and return either TRUE or FALSE according to Luhn CheckĪ1=123456789012349 -> =formula(A1) -> FALSEĪ1=123456789012347 -> =formula(A1) -> TRUE The structure of the IMEI is as follows: AA-BBBBBB-CCCCCC-DĪA-BBBBBB - is known as Type Allocation Code I'm pretty sure you know what an IMEI is. I know i'm probably just going to tickle you a little bit, this is a fairly easy challenge, but nevertheless i'd like to know if there's an alternative solution to the problem at hand. New to the board but been lurking around for quite some time.and this is the section i love most!
0 kommentar(er)
