Is there a way to drag the base function so that calc will calculate like if you do =a1+1 so that you don't have to change the value that you want to calculate from dec to whatever radix you're using?

[jadaja]

i’m making a spreadsheet of different numbering systems. i have been manually changing the formula =base(value;radix) by hand, changing the number you’re converting. in =a1+1 you simply drag the black box down and get the next number in sequence, is there a way to do similar with the base function? i’ve tried =base(a1+1, radix) and that didn’t work.

[karolus]

You have to convert the previous (text)-number to real number first.

=BASE(DECIMAL(A1;radix)+1;radix)

[jadaja]

thanx karolus. it works perfectly. sorry to take so long to respond, my internet access is sporadic.