Excel Formula to figure out number of bits required to finish the last octet of a subnet mask
my Business Applications professor gave us a question where we have an IP Address (160.35.128.93) and we have to use a formula to figure out what the required number of bits is required for the last octet of the IP Address and we have to make sure the number is rounded up. For example, his answer is that there are 6 required bits. The formula I'm using right now is IMLOG2(number_of_subnets+2) but after an hour of trying, I can't seem to get the right answer. Help would greatly appreciated.
microsoft-excel
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
|
show 1 more comment
my Business Applications professor gave us a question where we have an IP Address (160.35.128.93) and we have to use a formula to figure out what the required number of bits is required for the last octet of the IP Address and we have to make sure the number is rounded up. For example, his answer is that there are 6 required bits. The formula I'm using right now is IMLOG2(number_of_subnets+2) but after an hour of trying, I can't seem to get the right answer. Help would greatly appreciated.
microsoft-excel
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
The question you were given makes no sense. The subnet mask does not depend on the address to such precision; it could go all the way from e.g. /2 or /4 up to /30 or /31.
– grawity
Feb 8 at 20:02
To make sure that I didn't mess it up, here's the question word for word:
– SmartphoneUser
Feb 8 at 20:07
2. The formula to calculate the number of bits we require in the last octet for the subnet is Log2(number_of_subnets+2). Determine the function you need to use to find the number of bits we use to finish the subnet mask.
– SmartphoneUser
Feb 8 at 20:08
It is better to edit your question instead of adding information in comments. You have the formula, where is the problem exactly?
– cybernetic.nomad
Feb 8 at 21:11
Just use =LOG((num of subnets + 2),2). I don't think you have a complex number your dealing with.
– Brian
Feb 8 at 22:45
|
show 1 more comment
my Business Applications professor gave us a question where we have an IP Address (160.35.128.93) and we have to use a formula to figure out what the required number of bits is required for the last octet of the IP Address and we have to make sure the number is rounded up. For example, his answer is that there are 6 required bits. The formula I'm using right now is IMLOG2(number_of_subnets+2) but after an hour of trying, I can't seem to get the right answer. Help would greatly appreciated.
microsoft-excel
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
my Business Applications professor gave us a question where we have an IP Address (160.35.128.93) and we have to use a formula to figure out what the required number of bits is required for the last octet of the IP Address and we have to make sure the number is rounded up. For example, his answer is that there are 6 required bits. The formula I'm using right now is IMLOG2(number_of_subnets+2) but after an hour of trying, I can't seem to get the right answer. Help would greatly appreciated.
microsoft-excel
microsoft-excel
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
asked Feb 8 at 19:53
SmartphoneUser SmartphoneUser
163
163
The question you were given makes no sense. The subnet mask does not depend on the address to such precision; it could go all the way from e.g. /2 or /4 up to /30 or /31.
– grawity
Feb 8 at 20:02
To make sure that I didn't mess it up, here's the question word for word:
– SmartphoneUser
Feb 8 at 20:07
2. The formula to calculate the number of bits we require in the last octet for the subnet is Log2(number_of_subnets+2). Determine the function you need to use to find the number of bits we use to finish the subnet mask.
– SmartphoneUser
Feb 8 at 20:08
It is better to edit your question instead of adding information in comments. You have the formula, where is the problem exactly?
– cybernetic.nomad
Feb 8 at 21:11
Just use =LOG((num of subnets + 2),2). I don't think you have a complex number your dealing with.
– Brian
Feb 8 at 22:45
|
show 1 more comment
The question you were given makes no sense. The subnet mask does not depend on the address to such precision; it could go all the way from e.g. /2 or /4 up to /30 or /31.
– grawity
Feb 8 at 20:02
To make sure that I didn't mess it up, here's the question word for word:
– SmartphoneUser
Feb 8 at 20:07
2. The formula to calculate the number of bits we require in the last octet for the subnet is Log2(number_of_subnets+2). Determine the function you need to use to find the number of bits we use to finish the subnet mask.
– SmartphoneUser
Feb 8 at 20:08
It is better to edit your question instead of adding information in comments. You have the formula, where is the problem exactly?
– cybernetic.nomad
Feb 8 at 21:11
Just use =LOG((num of subnets + 2),2). I don't think you have a complex number your dealing with.
– Brian
Feb 8 at 22:45
The question you were given makes no sense. The subnet mask does not depend on the address to such precision; it could go all the way from e.g. /2 or /4 up to /30 or /31.
– grawity
Feb 8 at 20:02
The question you were given makes no sense. The subnet mask does not depend on the address to such precision; it could go all the way from e.g. /2 or /4 up to /30 or /31.
– grawity
Feb 8 at 20:02
To make sure that I didn't mess it up, here's the question word for word:
– SmartphoneUser
Feb 8 at 20:07
To make sure that I didn't mess it up, here's the question word for word:
– SmartphoneUser
Feb 8 at 20:07
2. The formula to calculate the number of bits we require in the last octet for the subnet is Log2(number_of_subnets+2). Determine the function you need to use to find the number of bits we use to finish the subnet mask.
– SmartphoneUser
Feb 8 at 20:08
2. The formula to calculate the number of bits we require in the last octet for the subnet is Log2(number_of_subnets+2). Determine the function you need to use to find the number of bits we use to finish the subnet mask.
– SmartphoneUser
Feb 8 at 20:08
It is better to edit your question instead of adding information in comments. You have the formula, where is the problem exactly?
– cybernetic.nomad
Feb 8 at 21:11
It is better to edit your question instead of adding information in comments. You have the formula, where is the problem exactly?
– cybernetic.nomad
Feb 8 at 21:11
Just use =LOG((num of subnets + 2),2). I don't think you have a complex number your dealing with.
– Brian
Feb 8 at 22:45
Just use =LOG((num of subnets + 2),2). I don't think you have a complex number your dealing with.
– Brian
Feb 8 at 22:45
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1403659%2fexcel-formula-to-figure-out-number-of-bits-required-to-finish-the-last-octet-of%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1403659%2fexcel-formula-to-figure-out-number-of-bits-required-to-finish-the-last-octet-of%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
The question you were given makes no sense. The subnet mask does not depend on the address to such precision; it could go all the way from e.g. /2 or /4 up to /30 or /31.
– grawity
Feb 8 at 20:02
To make sure that I didn't mess it up, here's the question word for word:
– SmartphoneUser
Feb 8 at 20:07
2. The formula to calculate the number of bits we require in the last octet for the subnet is Log2(number_of_subnets+2). Determine the function you need to use to find the number of bits we use to finish the subnet mask.
– SmartphoneUser
Feb 8 at 20:08
It is better to edit your question instead of adding information in comments. You have the formula, where is the problem exactly?
– cybernetic.nomad
Feb 8 at 21:11
Just use =LOG((num of subnets + 2),2). I don't think you have a complex number your dealing with.
– Brian
Feb 8 at 22:45