1. ## Excel2013 - trihexadecimal numbers

Hi all,

While recovering from injury on my first day here in the Caribbean, I was able to think about trihexadecimal numbers with primes and exponents while lazing under a palm tree on the beach.
So I came up with some simple formulas, which require Excel2013 or later:

The shortest one (no surprise here) is for rory:
=LOWER(BASE((13+1)*53*1741,6^2))

This one is for Maud:
=PROPER(BASE(44865889*(2^2^2^2*2^2+59-1),6^2))

..and of course, the greatest one is for RG:
=PROPER(BASE(15377*3880421,6^2)&" "&BASE(3^3^3*3*13-2473,6^2))

zeddy

2. Zeddy,

If you looked up "fun date" in the dictionary, I doubt your picture would be there!

A most fond welcome back.

3. Hi Maud

..now I know you have the latest Excel versions, so, did you get the results of my formulas?????

zeddy

4. zeddy, you're too clever by half

5. ..for you, it is simply
=LOWER(BASE(9197003*(2^2^2*2^2+2^2),6^2)&"-"&BASE(53*547,6^2))

(I liked that big prime number 9197003)

zeddy

6. Works nicely in LibreOffice 5.

cheers, Paul

7. Yes, very cool! But under a palm tree in the Caribbean?

Zeddy.png

8. Zeddy,

Glad you're enjoying the Sun & Waves! Now first you need more of those drinks with the umbrellas in them! Should do a lot to get your head out of the Excel!

I wish I had 2013 so I could see what fun you had in store for me. I guess I'll have to install Libre Office just to check it out.

Enjoy!

9. RG, Maud's screenshot should give you a clue - it's Rory, Maudibe, RetiredGeek and access-mdb in trihexawatchmacallit

10. Access,

Figured as much but I'd still like to see it happen!

11. To many of those umbrella thingies might result in another injury.

cheers, Paul

13. ..after too many of those umbrella thingies, some people might prefer to call them hexatridecimal numbers.

(it's BASE36, so I think tri-hex is better)

zeddy

14. Hi RG

..do you really want me to create a BASE function equivalent for Excel2010?

zeddy

15. Originally Posted by zeddy
Hi RG

..do you really want me to create a BASE function equivalent for Excel2010?

zeddy
Zeddy,

Thanks for the offer but I'd rather you just enjoy your vacation!

Page 1 of 2 12 Last

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•