[TriLUG] openoffice question

[sholton at mindspring.com]

Rick DeNatale <rick.denatale at gmail.com> writes:

>The upper range is, I think, 2^32-1, for an IPV4 address.  It's 32
>bits, or 256^4-1.

Um. yes.  That makes the formula:
=CONCATENATE(TEXT(MOD(INT(J81/POWER(2;24));POWER(2;8));0);".";TEXT(MOD(INT(J81/POWER(2;16));POWER(2;8));0);".";TEXT(MOD(INT(J81/POWER(2;8));POWER(2;8));0);".";TEXT(MOD(INT(J81);POWER(2;8));0))

Good catch. 
Which puts our favorite 192.168.1.2 at 3232235778.

I guess we're closer to running out of IP addresses than I'd thought ;-)


>
>--
>Rick DeNatale
>
>Visit the Project Mercury Wiki Site
>http://www.mercuryspacecraft.com/
>--
>TriLUG mailing list        : http://www.trilug.org/mailman/listinfo/trilug
>TriLUG Organizational FAQ  : http://trilug.org/faq/
>TriLUG Member Services FAQ : http://members.trilug.org/services_faq/


-- 
Steve Holton
sholton at mindspring.com
"Convenience causes blindness. Think about it."