Why can't I do math inside of MAX() in Excel 2010?Why can't I change the table size in Excel (large data...
Process to change collation on a database
A universal method for left-hand alignment of a sequence of equalities
How to deal with an incendiary email that was recalled
Why Smart Plugs don't require setting port forwarding on router and how to accomplish this with NodeMCU (ESP8266)
If I delete my router's history can my ISP still provide it to my parents?
Why is "points exist" not an axiom in geometry?
How to acknowledge an embarrassing job interview, now that I work directly with the interviewer?
Word or phrase for showing great skill at something without formal training in it
If I sold a PS4 game I owned the disc for, can I reinstall it digitally?
Would these multi-classing house rules cause unintended problems?
How should I handle players who ignore the session zero agreement?
Dilemma of explaining to interviewer that he is the reason for declining second interview
Why doesn't "auto ch = unsigned char{'p'}" compile under C++ 17?
What does Cypher mean when he says Neo is "gonna pop"?
Does Improved Divine Smite trigger when a paladin makes an unarmed strike?
Jumping Numbers
Groups acting on trees
Should I write a companion book/blog?
A minimum of two personnel "are" or "is"?
What kind of hardware implements Fourier transform?
We are very unlucky in my court
Is there some relative to Dutch word "kijken" in German?
Cryptic with missing capitals
What is the wife of a henpecked husband called?
Why can't I do math inside of MAX() in Excel 2010?
Why can't I change the table size in Excel (large data set)?Total row doesn't work properly, Excel 2010Fill handle doesn't work, Excel 2010Excel 2010 separating registers with the same name on dynamic tablesExcel 2010: Combine Two Tables in Pivot TableTwo identical values not treated equally in ExcelAn Excel 2010 FormulaExcel 2010 Win 7Is it possible to use Index and Match or something similar in Microsoft Excel to find last filled number row for two sets of numbers in same column?Excel 2010: Pivot table: insert calculated fields with sum or average columns
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 8 mins ago
Michael DuncanMichael Duncan
92
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 8 mins ago
Michael DuncanMichael Duncan
92
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 8 mins ago
Michael DuncanMichael Duncan
92
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 8 mins ago
Michael DuncanMichael Duncan
92
asked 8 mins ago
Michael DuncanMichael Duncan
92
asked 8 mins ago
Michael DuncanMichael Duncan
92
asked 8 mins ago
Michael DuncanMichael Duncan
92
asked 8 mins ago
Michael DuncanMichael Duncan
92
92
add a comment |
add a 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%2f1410646%2fwhy-cant-i-do-math-inside-of-max-in-excel-2010%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%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
