What is Excel #N/A error abbreviation, looking for?
In MS-Excel we have below functions return errors:
#N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM!
I think about what is the complete error massage, which each one are represents?
Of course, seams the #N/A one is abbreviation of two words. What is "N" and "A" looking for?
microsoft-excel worksheet-function microsoft-excel-2007 microsoft-excel-2016
asked Dec 7 at 5:54
mgae2m
10217
add a comment |
In MS-Excel we have below functions return errors:
#N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM!
I think about what is the complete error massage, which each one are represents?
Of course, seams the #N/A one is abbreviation of two words. What is "N" and "A" looking for?
microsoft-excel worksheet-function microsoft-excel-2007 microsoft-excel-2016
asked Dec 7 at 5:54
mgae2m
10217
What is "N" and "A" looking for? Not Available.
– Akina
Dec 7 at 6:53
The title indicates this is just about #N/A. The body suggests that you might be asking about all of the error messages. This information is readily available in Excel help or with a Google search. Can you clarify what you're looking for that is unclear?
– fixer1234
Dec 7 at 8:17
@fixer1234Specially I need reference for What is #N/A stands for? and I bring the list of the Excel errors with special note at #N/A meaning need. Regards.
– mgae2m
Dec 9 at 14:16
@Akina, Please bring a reference for this mean. @ fixer1234, I so studied some general helps and did search in google, bot nothing found about the "What is #N/A stands for". If you now, please prefer a reference. Regards.
– mgae2m
Dec 9 at 14:21
add a comment |
In MS-Excel we have below functions return errors:
#N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM!
I think about what is the complete error massage, which each one are represents?
Of course, seams the #N/A one is abbreviation of two words. What is "N" and "A" looking for?
microsoft-excel worksheet-function microsoft-excel-2007 microsoft-excel-2016
asked Dec 7 at 5:54
mgae2m
10217
In MS-Excel we have below functions return errors:
#N/A #REF! #NAME? #DIV/0! #NULL! #VALUE! #NUM!
I think about what is the complete error massage, which each one are represents?
Of course, seams the #N/A one is abbreviation of two words. What is "N" and "A" looking for?
microsoft-excel worksheet-function microsoft-excel-2007 microsoft-excel-2016
microsoft-excel worksheet-function microsoft-excel-2007 microsoft-excel-2016
asked Dec 7 at 5:54
mgae2m
10217
asked Dec 7 at 5:54
mgae2m
10217
asked Dec 7 at 5:54
mgae2m
10217
asked Dec 7 at 5:54
mgae2m
10217
asked Dec 7 at 5:54
mgae2m
10217
10217
What is "N" and "A" looking for? Not Available.
– Akina
Dec 7 at 6:53
The title indicates this is just about #N/A. The body suggests that you might be asking about all of the error messages. This information is readily available in Excel help or with a Google search. Can you clarify what you're looking for that is unclear?
– fixer1234
Dec 7 at 8:17
@fixer1234Specially I need reference for What is #N/A stands for? and I bring the list of the Excel errors with special note at #N/A meaning need. Regards.
– mgae2m
Dec 9 at 14:16
@Akina, Please bring a reference for this mean. @ fixer1234, I so studied some general helps and did search in google, bot nothing found about the "What is #N/A stands for". If you now, please prefer a reference. Regards.
– mgae2m
Dec 9 at 14:21
add a comment |
What is "N" and "A" looking for? Not Available.
– Akina
Dec 7 at 6:53
The title indicates this is just about #N/A. The body suggests that you might be asking about all of the error messages. This information is readily available in Excel help or with a Google search. Can you clarify what you're looking for that is unclear?
– fixer1234
Dec 7 at 8:17
@fixer1234Specially I need reference for What is #N/A stands for? and I bring the list of the Excel errors with special note at #N/A meaning need. Regards.
– mgae2m
Dec 9 at 14:16
@Akina, Please bring a reference for this mean. @ fixer1234, I so studied some general helps and did search in google, bot nothing found about the "What is #N/A stands for". If you now, please prefer a reference. Regards.
– mgae2m
Dec 9 at 14:21
What is "N" and "A" looking for? Not Available.
– Akina
Dec 7 at 6:53
What is "N" and "A" looking for? Not Available.
– Akina
Dec 7 at 6:53
The title indicates this is just about #N/A. The body suggests that you might be asking about all of the error messages. This information is readily available in Excel help or with a Google search. Can you clarify what you're looking for that is unclear?
– fixer1234
Dec 7 at 8:17
The title indicates this is just about #N/A. The body suggests that you might be asking about all of the error messages. This information is readily available in Excel help or with a Google search. Can you clarify what you're looking for that is unclear?
– fixer1234
Dec 7 at 8:17
@fixer1234Specially I need reference for What is #N/A stands for? and I bring the list of the Excel errors with special note at #N/A meaning need. Regards.
– mgae2m
Dec 9 at 14:16
@fixer1234Specially I need reference for What is #N/A stands for? and I bring the list of the Excel errors with special note at #N/A meaning need. Regards.
– mgae2m
Dec 9 at 14:16
@Akina, Please bring a reference for this mean. @ fixer1234, I so studied some general helps and did search in google, bot nothing found about the "What is #N/A stands for". If you now, please prefer a reference. Regards.
– mgae2m
Dec 9 at 14:21
@Akina, Please bring a reference for this mean. @ fixer1234, I so studied some general helps and did search in google, bot nothing found about the "What is #N/A stands for". If you now, please prefer a reference. Regards.
– mgae2m
Dec 9 at 14:21
add a comment |
1 Answer
1
active
oldest
votes
Each Error has a meaning & reason.
For example:
#N/A, stands for Not Available and indicates that, the Formula cannot finds the referenced data.
#Ref!, is Reference and indicates that the reference is invalid.
For more information and better understanding check the following Web links.
https://www.dummies.com/software/microsoft-office/excel/excel-error-messages-to-get-to-know/
https://www.ozgrid.com/Excel/formula-errors.htm
answered Dec 7 at 6:10
Rajesh S
3,6481522
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
1
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
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%2f1381550%2fwhat-is-excel-n-a-error-abbreviation-looking-for%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Each Error has a meaning & reason.
For example:
#N/A, stands for Not Available and indicates that, the Formula cannot finds the referenced data.
#Ref!, is Reference and indicates that the reference is invalid.
For more information and better understanding check the following Web links.
https://www.dummies.com/software/microsoft-office/excel/excel-error-messages-to-get-to-know/
https://www.ozgrid.com/Excel/formula-errors.htm
answered Dec 7 at 6:10
Rajesh S
3,6481522
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
1
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
add a comment |
Each Error has a meaning & reason.
For example:
#N/A, stands for Not Available and indicates that, the Formula cannot finds the referenced data.
#Ref!, is Reference and indicates that the reference is invalid.
For more information and better understanding check the following Web links.
https://www.dummies.com/software/microsoft-office/excel/excel-error-messages-to-get-to-know/
https://www.ozgrid.com/Excel/formula-errors.htm
answered Dec 7 at 6:10
Rajesh S
3,6481522
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
1
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
add a comment |
Each Error has a meaning & reason.
For example:
#N/A, stands for Not Available and indicates that, the Formula cannot finds the referenced data.
#Ref!, is Reference and indicates that the reference is invalid.
For more information and better understanding check the following Web links.
https://www.dummies.com/software/microsoft-office/excel/excel-error-messages-to-get-to-know/
https://www.ozgrid.com/Excel/formula-errors.htm
answered Dec 7 at 6:10
Rajesh S
3,6481522
Each Error has a meaning & reason.
For example:
#N/A, stands for Not Available and indicates that, the Formula cannot finds the referenced data.
#Ref!, is Reference and indicates that the reference is invalid.
For more information and better understanding check the following Web links.
https://www.dummies.com/software/microsoft-office/excel/excel-error-messages-to-get-to-know/
https://www.ozgrid.com/Excel/formula-errors.htm
answered Dec 7 at 6:10
Rajesh S
3,6481522
edited Dec 7 at 8:40
answered Dec 7 at 6:10
Rajesh S
3,6481522
answered Dec 7 at 6:10
Rajesh S
3,6481522
answered Dec 7 at 6:10
Rajesh S
3,6481522
3,6481522
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
1
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
add a comment |
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
1
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
@fixer1234,, it's good idea to include some basic infos along with links,, this is very first time I've used links, since I've found with many answers. ☺
– Rajesh S
Dec 7 at 8:32
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
Regards you, Please prefer a reference for Not Available is what is #N/A stands for. yours.
– mgae2m
Dec 9 at 14:22
1
1
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
@mgae2m: exceljet.net/excel-functions/excel-na-function. What the error codes represent is well documented. The abbreviations Microsoft chose are arbitrary. N/A is generally assumed to be derived from "Not Available". Beyond that, only Microsoft can say the actual basis on which the abbreviations were selected.
– fixer1234
Dec 9 at 23:19
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
Very truly yours, with best regards.
– mgae2m
Dec 10 at 4:12
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
@mgae2m,, glad to help you,, keep asking ☺
– Rajesh S
Dec 10 at 5:49
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.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- 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%2f1381550%2fwhat-is-excel-n-a-error-abbreviation-looking-for%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 is "N" and "A" looking for? Not Available.
– Akina
Dec 7 at 6:53
The title indicates this is just about #N/A. The body suggests that you might be asking about all of the error messages. This information is readily available in Excel help or with a Google search. Can you clarify what you're looking for that is unclear?
– fixer1234
Dec 7 at 8:17
@fixer1234Specially I need reference for What is #N/A stands for? and I bring the list of the Excel errors with special note at #N/A meaning need. Regards.
– mgae2m
Dec 9 at 14:16
@Akina, Please bring a reference for this mean. @ fixer1234, I so studied some general helps and did search in google, bot nothing found about the "What is #N/A stands for". If you now, please prefer a reference. Regards.
– mgae2m
Dec 9 at 14:21