Isn't it?
=10*INT(A1/3)+MOD(A1,3)
where A1 contains the base 10 number you want to convert.
This is a discussion on changing base within the Excel Questions forums, part of the Question Forums category; i am looking to convert base 10 numbers into base 3. i know there are functions to move between 2, ...
i am looking to convert base 10 numbers into base 3. i know there are functions to move between 2, 8, 10 and 16 but can excel handle base 3.
Isn't it?
=10*INT(A1/3)+MOD(A1,3)
where A1 contains the base 10 number you want to convert.
works up to 8, but 9 should be 100 in base 3. your formula returns 30, which is illegal in base 3
Morefunc add-in has an function CHBASE, you might find helpfulOriginally Posted by lordrom
******** ******************** ************************************************************************>
Microsoft Excel - Book1 ___Running: xl2002 XP : OS = Windows XP
File Edit View Insert Options Tools Data Window Help About
=
A B C D 1 100 9 * *
Sheet1 *
[HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.
exactly what i'm after
cheers
now, where do i find morefunc? i trust it will cost?
Actually it's FREE, there's a add-in link somewhereOriginally Posted by lordrom
http://216.92.17.166/board2/viewtopic.php?t=49750
I'd better go back to school!Originally Posted by lordrom
Andrew,Originally Posted by Andrew Poulsom
What would be the Excel functions to convert?
That's the problem. It involves iteration so I don't think it can be done with standard Excel funtions. Here is a UDF I found:
Code:Function baseconv(InputNum, BaseNum) Dim quotient, remainder As Single Dim answer As String quotient = InputNum ' Set quotient to number to convert. remainder = InputNum ' Set remainder to number to convert. answer = "" Do While quotient <> 0 ' Loop while quotient is not zero. ' Store the remainder of the quotient divided by base number in a ' variable called remainder. remainder = quotient Mod BaseNum ' Reset quotient variable to the integer value of the quotient ' divided by base number. quotient = Int(quotient / BaseNum) ' Reset answer to contain remainder and the previous answer. answer = remainder & answer ' Convert answer variable to a number. Loop baseconv = Val(answer) End Function
Like this thread? Share it with others