How is XFD = 16,384?
-
My afternoon obsession with MS Office Excel continued and thought, how will XFD equals 16,384? Did the Math already! Damn bored!
-
My afternoon obsession with MS Office Excel continued and thought, how will XFD equals 16,384? Did the Math already! Damn bored!
For bonus points, do that calculation using Excel formulas...
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels) -
For bonus points, do that calculation using Excel formulas...
Proud to have finally moved to the A-Ark. Which one are you in?
Author of the Guardians Saga (Sci-Fi/Fantasy novels)Great idea! :mad:
-
My afternoon obsession with MS Office Excel continued and thought, how will XFD equals 16,384? Did the Math already! Damn bored!
Perhaps you could have just done a range-fill, starting with 1, and see what happens at the other end.
"The difference between genius and stupidity is that genius has its limits." - Albert Einstein
"As far as we know, our computer has never had an undetected error." - Weisert
"If you are searching for perfection in others, then you seek disappointment. If you are seek perfection in yourself, then you will find failure." - Balboos HaGadol Mar 2010
-
My afternoon obsession with MS Office Excel continued and thought, how will XFD equals 16,384? Did the Math already! Damn bored!
Think of base-26 (there are 26 letters in the English alphabet)... So XFD is X * 26^2 + F * 26 + D, where X = 24, F = 6 and D = 4... So it comes to 16224 + 156 + 4 = 16384
Skipper: We'll fix it. Alex: Fix it? How you gonna fix this? Skipper: Grit, spit and a whole lotta duct tape.
