How to use GAMMA function _xlfn.GAMMA?
Microsoft website has an introduction on GAMMA function.
I could download it and have a look, it's a ".xlsx" file and the formula is shown as =_xlfn.GAMMA(2.5).
However, when I create a new excel ".xlsx" file, I can't use it, neither by write formula as =_xlfn.GAMMA(2.5)" or "=GAMMA(2.5).
Did I missed something? Is there some library I shall register, like using Solver function?
Clarification
@dave-rook is right.
I'm using Excel 2007. The msdn page says "GAMMA" function applies to Excel 2013, so the problem is the version.
microsoft-excel
asked Aug 27 '13 at 15:15
athosathos
83272038
add a comment |
Microsoft website has an introduction on GAMMA function.
I could download it and have a look, it's a ".xlsx" file and the formula is shown as =_xlfn.GAMMA(2.5).
However, when I create a new excel ".xlsx" file, I can't use it, neither by write formula as =_xlfn.GAMMA(2.5)" or "=GAMMA(2.5).
Did I missed something? Is there some library I shall register, like using Solver function?
Clarification
@dave-rook is right.
I'm using Excel 2007. The msdn page says "GAMMA" function applies to Excel 2013, so the problem is the version.
microsoft-excel
asked Aug 27 '13 at 15:15
athosathos
83272038
What version of Excel are you using?
– Dave
Aug 27 '13 at 15:16
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself.
– user222864
Aug 27 '13 at 15:59
is there some library can do that? i know that excel can have plugin's..
– athos
Aug 27 '13 at 16:16
add a comment |
Microsoft website has an introduction on GAMMA function.
I could download it and have a look, it's a ".xlsx" file and the formula is shown as =_xlfn.GAMMA(2.5).
However, when I create a new excel ".xlsx" file, I can't use it, neither by write formula as =_xlfn.GAMMA(2.5)" or "=GAMMA(2.5).
Did I missed something? Is there some library I shall register, like using Solver function?
Clarification
@dave-rook is right.
I'm using Excel 2007. The msdn page says "GAMMA" function applies to Excel 2013, so the problem is the version.
microsoft-excel
asked Aug 27 '13 at 15:15
athosathos
83272038
Microsoft website has an introduction on GAMMA function.
I could download it and have a look, it's a ".xlsx" file and the formula is shown as =_xlfn.GAMMA(2.5).
However, when I create a new excel ".xlsx" file, I can't use it, neither by write formula as =_xlfn.GAMMA(2.5)" or "=GAMMA(2.5).
Did I missed something? Is there some library I shall register, like using Solver function?
Clarification
@dave-rook is right.
I'm using Excel 2007. The msdn page says "GAMMA" function applies to Excel 2013, so the problem is the version.
microsoft-excel
microsoft-excel
asked Aug 27 '13 at 15:15
athosathos
83272038
asked Aug 27 '13 at 15:15
athosathos
83272038
edited Aug 28 '13 at 2:50
athos
asked Aug 27 '13 at 15:15
athosathos
83272038
asked Aug 27 '13 at 15:15
athosathos
83272038
asked Aug 27 '13 at 15:15
athosathos
83272038
83272038
What version of Excel are you using?
– Dave
Aug 27 '13 at 15:16
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself.
– user222864
Aug 27 '13 at 15:59
is there some library can do that? i know that excel can have plugin's..
– athos
Aug 27 '13 at 16:16
add a comment |
What version of Excel are you using?
– Dave
Aug 27 '13 at 15:16
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself.
– user222864
Aug 27 '13 at 15:59
is there some library can do that? i know that excel can have plugin's..
– athos
Aug 27 '13 at 16:16
What version of Excel are you using?
– Dave
Aug 27 '13 at 15:16
What version of Excel are you using?
– Dave
Aug 27 '13 at 15:16
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself.
– user222864
Aug 27 '13 at 15:59
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself.
– user222864
Aug 27 '13 at 15:59
is there some library can do that? i know that excel can have plugin's..
– athos
Aug 27 '13 at 16:16
is there some library can do that? i know that excel can have plugin's..
– athos
Aug 27 '13 at 16:16
add a comment |
2 Answers
2
active
oldest
votes
In excel 2003 and up you can use
=EXP(GAMMALN(value))
For all positive values
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
add a comment |
If GAMMALN is not available under your language settings, you may need to be using the following formula:
=GAMMA.LN(EXP(value))
edited Feb 8 '14 at 21:20
random♦
12.9k84757
answered Feb 8 '14 at 17:08
mariamaria
1
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
add a comment |
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%2f637298%2fhow-to-use-gamma-function-xlfn-gamma%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
In excel 2003 and up you can use
=EXP(GAMMALN(value))
For all positive values
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
add a comment |
In excel 2003 and up you can use
=EXP(GAMMALN(value))
For all positive values
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
add a comment |
In excel 2003 and up you can use
=EXP(GAMMALN(value))
For all positive values
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
In excel 2003 and up you can use
=EXP(GAMMALN(value))
For all positive values
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
answered Sep 4 '13 at 20:46
Joel TaylorJoel Taylor
88369
88369
add a comment |
add a comment |
If GAMMALN is not available under your language settings, you may need to be using the following formula:
=GAMMA.LN(EXP(value))
edited Feb 8 '14 at 21:20
random♦
12.9k84757
answered Feb 8 '14 at 17:08
mariamaria
1
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
add a comment |
If GAMMALN is not available under your language settings, you may need to be using the following formula:
=GAMMA.LN(EXP(value))
edited Feb 8 '14 at 21:20
random♦
12.9k84757
answered Feb 8 '14 at 17:08
mariamaria
1
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
add a comment |
If GAMMALN is not available under your language settings, you may need to be using the following formula:
=GAMMA.LN(EXP(value))
edited Feb 8 '14 at 21:20
random♦
12.9k84757
answered Feb 8 '14 at 17:08
mariamaria
1
If GAMMALN is not available under your language settings, you may need to be using the following formula:
=GAMMA.LN(EXP(value))
edited Feb 8 '14 at 21:20
random♦
12.9k84757
answered Feb 8 '14 at 17:08
mariamaria
1
edited Feb 8 '14 at 21:20
random♦
12.9k84757
edited Feb 8 '14 at 21:20
random♦
12.9k84757
edited Feb 8 '14 at 21:20
random♦
12.9k84757
12.9k84757
answered Feb 8 '14 at 17:08
mariamaria
1
answered Feb 8 '14 at 17:08
mariamaria
1
answered Feb 8 '14 at 17:08
mariamaria
1
1
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
add a comment |
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
This is better as a comment perhaps
– Dave M
Feb 8 '14 at 18:01
add a comment |
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%2f637298%2fhow-to-use-gamma-function-xlfn-gamma%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
What version of Excel are you using?
– Dave
Aug 27 '13 at 15:16
youre right the function isnt included with the workbook. it does work on the embed spreadsheet on the web, but its not anywhere to find within the downloaded file itself.
– user222864
Aug 27 '13 at 15:59
is there some library can do that? i know that excel can have plugin's..
– athos
Aug 27 '13 at 16:16