Forgot your password?
Or sign in with one of these services
Inky last won the day on October 15 2019
Inky had the most liked content!
April 1
March 24
March 19
March 9
February 28
January 19
December 20, 2020
December 11, 2020
See all updates by Inky
Need help creating an Excel formula that turns a whole number into an IP address
carlsson
Does it need to be a single formula, or do you have the luxury to be able to use additional helper cells?
=CONCAT(INT(B1/(2^24));".";INT((B1-INT(B1/(2^24))*2^24)/(2^16));".";INT((B1-INT(B1/(2^24))*2^24-INT((B1-INT(B1/(2^24))*2^24)/(2^16))*2^16)/256);".";B1-INT(B1/(2^24))*2^24-INT((B1-INT(B1/(2^24))*2^24)/(2^16))*2^16-(INT((B1-INT(B1/(2^24))*2^24-INT((B1-INT(B1/(2^24))*2^24)/(2^16))*2^16)/256)*256))
Like us on Facebook
Follow us on Twitter
AtariAge on Instagram
Watch us on YouTube
Chat on Discord