answersLogoWhite

0


Best Answer

Use the LOG function.

=LOG(n,b)

n = Number

b = Base

=LOG(2,10) = 0.30103

User Avatar

Wiki User

6y ago
This answer is:
User Avatar
User Avatar

2here 2there

Lvl 1
2y ago
The question is about Log2. The Log2 formula of for example 36 is =LOG(36,2)

Add your answer:

Earn +20 pts
Q: How do you calculate Log2 in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How many bits need to represent decimal number 12500?

If you want an unsigned integer, you can calculate this as log2(12500), rounded up. You can calculate the log2 function (logarithm to the base 2), in this case, by dividing ln(12500) / ln(2).


How to solve Log 2 Log 2 Log 2 X equals 0 here 2 is the base not any number?

I guess you mean log2{log2[log2(x)]} = 0 ?Let Y = {log2[log2(x)]}, so you have log2[Y] = 0The solution to this is Y = 1,Then you a simpler equation: log2[log2(x)] = 1Let Z = log2(x), so log2[Z] = 1, solves to Z = 2,so log2(x) = 2, and x = 4


How do you solve log base 2 of 3 to the 1000?

log2(31000) = 1000 log2(3)log2(3) = 1.585 (rounded)1000 log2(3) = log2(31000) = 1,584.96(rounded)


What is 102a if log2 equals a and log3 equals b?

Find 102a if log2=a and log3=b B has no purpose in this question If a=log2, then 102a =102(log2)


Given that p equals log2q find an expression in terms of p for log2 routeq and log2 8q?

log2 sqrt(q) = p/2 log2 8q = 3 + p And it is root, not route.


Why is MS Excel is called Excel?

MS-Excel is a powerful worksheet & you calculate , syncronize many hard calculation, so MS-Excel is called Excel.


What formula is used to calculate quantity?

You can calculate quantity in Excel with the SUM function.


How do you calculate sharpe ratio in Excel?

The related link provides an excel template and some notes on how to calculate the sharpe ratio..pretty simple and effective.


How do you solve log base 2 of x - 3 log base 2 of 5 equals 2 log base 2 of 10?

[log2 (x - 3)](log2 5) = 2log2 10 log2 (x - 3) = 2log2 10/log2 5 log2 (x - 3) = 2(log 10/log 2)/(log5/log 2) log2 (x - 3) = 2(log 10/log 5) log2 (x - 3) = 2(1/log 5) log2 (x - 3) = 2/log 5 x - 3 = 22/log x = 3 + 22/log 5


How do you calculate degrees of freedom on excel?

Utilizing the visual basic functions built into excel worksheets you can calculate degrees of freedom. The function call that you use for this is "degrees_freedom".


How many octaves between 100 Hz and 6400 Hz?

log2(6400/100) = log2(64) = 6


What is log2 8 equals 3 in exponential form?

log2(8) = 3 means (2)3 = 8