Ask Your Question

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?

asked 2017-01-22 18:48:55 +0200

jadaja gravatar image

updated 2017-01-22 18:49:31 +0200

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-22 21:35:40 +0200

karolus gravatar image

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

edit flag offensive delete link more


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

jadaja gravatar imagejadaja ( 2017-01-29 09:31:14 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-22 18:48:55 +0200

Seen: 43 times

Last updated: Jan 22 '17