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))
I don't have the English language version of Excel, so replace CONCAT and INT as required.
Like us on Facebook
Follow us on Twitter
AtariAge on Instagram
Watch us on YouTube
Chat on Discord