Why can't I do math inside of MAX() in Excel 2010?
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
MAX(Table[one]) works fine. But when I try MAX(Table[one]*Table[two]), or even more simply MAX(Table[one]*2), it returns #VALUE!. It looks good in the evaluator until the very end. Why so??
microsoft-excel-2010
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
add a comment |
MAX(Table[one]) works fine. But when I try MAX(Table[one]*Table[two]), or even more simply MAX(Table[one]*2), it returns #VALUE!. It looks good in the evaluator until the very end. Why so??
microsoft-excel-2010
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
What areTable[one]andTable[two]- show examples.
– Hannu
Mar 2 at 13:15
add a comment |
MAX(Table[one]) works fine. But when I try MAX(Table[one]*Table[two]), or even more simply MAX(Table[one]*2), it returns #VALUE!. It looks good in the evaluator until the very end. Why so??
microsoft-excel-2010
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
MAX(Table[one]) works fine. But when I try MAX(Table[one]*Table[two]), or even more simply MAX(Table[one]*2), it returns #VALUE!. It looks good in the evaluator until the very end. Why so??
microsoft-excel-2010
microsoft-excel-2010
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
asked Mar 2 at 3:04
Michael DuncanMichael Duncan
194
194
What areTable[one]andTable[two]- show examples.
– Hannu
Mar 2 at 13:15
add a comment |
What areTable[one]andTable[two]- show examples.
– Hannu
Mar 2 at 13:15
What are
Table[one] and Table[two]- show examples.– Hannu
Mar 2 at 13:15
What are
Table[one] and Table[two]- show examples.– Hannu
Mar 2 at 13:15
add a comment |
1 Answer
1
active
oldest
votes
Multiply Tables is just like multiplying their range equivalents. For example, say our two ranges are A1:C3 and E5:G7 (
note they are both 3x3). We can use:
=MAX(A1:C3*E5:G7)
in E1, but it must be array-entered:
Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key. If this is done correctly, the formula will appear with curly braces around it in the Formula Bar.
Use the same technique with the numeric part of your Tables.
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
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%2f1410646%2fwhy-cant-i-do-math-inside-of-max-in-excel-2010%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
Multiply Tables is just like multiplying their range equivalents. For example, say our two ranges are A1:C3 and E5:G7 (
note they are both 3x3). We can use:
=MAX(A1:C3*E5:G7)
in E1, but it must be array-entered:
Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key. If this is done correctly, the formula will appear with curly braces around it in the Formula Bar.
Use the same technique with the numeric part of your Tables.
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
add a comment |
Multiply Tables is just like multiplying their range equivalents. For example, say our two ranges are A1:C3 and E5:G7 (
note they are both 3x3). We can use:
=MAX(A1:C3*E5:G7)
in E1, but it must be array-entered:
Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key. If this is done correctly, the formula will appear with curly braces around it in the Formula Bar.
Use the same technique with the numeric part of your Tables.
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
add a comment |
Multiply Tables is just like multiplying their range equivalents. For example, say our two ranges are A1:C3 and E5:G7 (
note they are both 3x3). We can use:
=MAX(A1:C3*E5:G7)
in E1, but it must be array-entered:
Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key. If this is done correctly, the formula will appear with curly braces around it in the Formula Bar.
Use the same technique with the numeric part of your Tables.
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
Multiply Tables is just like multiplying their range equivalents. For example, say our two ranges are A1:C3 and E5:G7 (
note they are both 3x3). We can use:
=MAX(A1:C3*E5:G7)
in E1, but it must be array-entered:
Array formulas must be entered with Ctrl + Shift + Enter rather than just the Enter key. If this is done correctly, the formula will appear with curly braces around it in the Formula Bar.
Use the same technique with the numeric part of your Tables.
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
answered Mar 2 at 15:47
Gary's StudentGary's Student
14.2k31733
14.2k31733
add a comment |
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%2f1410646%2fwhy-cant-i-do-math-inside-of-max-in-excel-2010%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 are
Table[one]andTable[two]- show examples.– Hannu
Mar 2 at 13:15