Ask Your Question
0

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
0

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

karolus gravatar image

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

=BASE(DECIMAL(A1;radix)+1;radix)
edit flag offensive delete link more

Comments

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

Stats

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

Seen: 43 times

Last updated: Jan 22 '17