Multiplying Two Cells Returns ZeroComparing two strings in Excel?Conditional Formatting - Highlight An Entire...
How much character growth crosses the line into breaking the character
How to decide convergence of Integrals
Open a doc from terminal, but not by its name
Diode in opposite direction?
Are lightweight LN wallets vulnerable to transaction withholding?
Can a significant change in incentives void an employment contract?
What (else) happened July 1st 1858 in London?
Why is Arduino resetting while driving motors?
Bob has never been a M before
anything or something to eat
How should I respond when I lied about my education and the company finds out through background check?
THT: What is a squared annular “ring”?
Could solar power be utilized and substitute coal in the 19th Century
Is XSS in canonical link possible?
Freedom of speech and where it applies
How do I repair my stair bannister?
Drawing ramified coverings with tikz
Should I stop contributing to retirement accounts?
A Permanent Norse Presence in America
Is there a conventional notation or name for the slip angle?
How to color a curve
Why does Async/Await work properly when the loop is inside the async function and not the other way around?
If a character with the Alert feat rolls a crit fail on their Perception check, are they surprised?
Greco-Roman egalitarianism
Multiplying Two Cells Returns Zero
Comparing two strings in Excel?Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a ColumnCount how many cells have a number greater than zeroHow do I copy a column of numbers to another column while excluding cells with zero or blank?Cannot Use Autosum on cells that Contain FormulasSubtract Two Cells. Result valueComparing two range of cells to find out the number of matchesExcel dynamic list returns a zero when referenceing blank cellsHow to sum a column with cells containing text?Preventing the entry of formulas in cells
I created a formula field that multiplies two cells and it returns 0 even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32
J2 = 380
Any help would be appreciated
microsoft-excel
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
asked May 21 '15 at 19:42
Y SilberY Silber
112
|
show 2 more comments
I created a formula field that multiplies two cells and it returns 0 even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32
J2 = 380
Any help would be appreciated
microsoft-excel
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
asked May 21 '15 at 19:42
Y SilberY Silber
112
1
I don't know what is the problem, but here are some tips: Check the format of all the three cells for strange settings, set the formats to "general". Try to multiply both cells with 1.
– Máté Juhász
May 21 '15 at 20:16
1
In addition to the suggestion by @MátéJuhász set the formats to Number. Most likely, at least one of the cells is formatted as text. For math operations, Excel treats text as0.
– Engineer Toast
May 21 '15 at 20:34
2
@YSilber, can you share the file on a file sharing site?
– teylyn
May 21 '15 at 20:51
3
Try=value(J2)*value(K2). If this is correct, then one or both of the values is text. BTW, by default, text is left aligned; true numbers are right aligned.
– Jeeped
May 22 '15 at 1:32
3
Make sure your system work with decimal point instead of comma. Maybe 16.32 should be 16,32.
– jcbermu
May 25 '15 at 9:30
|
show 2 more comments
I created a formula field that multiplies two cells and it returns 0 even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32
J2 = 380
Any help would be appreciated
microsoft-excel
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
asked May 21 '15 at 19:42
Y SilberY Silber
112
I created a formula field that multiplies two cells and it returns 0 even if the numbers in those cells are greater than 0.
The formula is
=K2*J2
The values I see in those cells are:
K2 = 16.32
J2 = 380
Any help would be appreciated
microsoft-excel
microsoft-excel
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
asked May 21 '15 at 19:42
Y SilberY Silber
112
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
asked May 21 '15 at 19:42
Y SilberY Silber
112
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
edited May 21 '15 at 20:48
Engineer Toast
2,9181828
2,9181828
asked May 21 '15 at 19:42
Y SilberY Silber
112
asked May 21 '15 at 19:42
Y SilberY Silber
112
asked May 21 '15 at 19:42
Y SilberY Silber
112
112
1
I don't know what is the problem, but here are some tips: Check the format of all the three cells for strange settings, set the formats to "general". Try to multiply both cells with 1.
– Máté Juhász
May 21 '15 at 20:16
1
In addition to the suggestion by @MátéJuhász set the formats to Number. Most likely, at least one of the cells is formatted as text. For math operations, Excel treats text as0.
– Engineer Toast
May 21 '15 at 20:34
2
@YSilber, can you share the file on a file sharing site?
– teylyn
May 21 '15 at 20:51
3
Try=value(J2)*value(K2). If this is correct, then one or both of the values is text. BTW, by default, text is left aligned; true numbers are right aligned.
– Jeeped
May 22 '15 at 1:32
3
Make sure your system work with decimal point instead of comma. Maybe 16.32 should be 16,32.
– jcbermu
May 25 '15 at 9:30
|
show 2 more comments
1
I don't know what is the problem, but here are some tips: Check the format of all the three cells for strange settings, set the formats to "general". Try to multiply both cells with 1.
– Máté Juhász
May 21 '15 at 20:16
1
In addition to the suggestion by @MátéJuhász set the formats to Number. Most likely, at least one of the cells is formatted as text. For math operations, Excel treats text as0.
– Engineer Toast
May 21 '15 at 20:34
2
@YSilber, can you share the file on a file sharing site?
– teylyn
May 21 '15 at 20:51
3
Try=value(J2)*value(K2). If this is correct, then one or both of the values is text. BTW, by default, text is left aligned; true numbers are right aligned.
– Jeeped
May 22 '15 at 1:32
3
Make sure your system work with decimal point instead of comma. Maybe 16.32 should be 16,32.
– jcbermu
May 25 '15 at 9:30
1
1
I don't know what is the problem, but here are some tips: Check the format of all the three cells for strange settings, set the formats to "general". Try to multiply both cells with 1.
– Máté Juhász
May 21 '15 at 20:16
I don't know what is the problem, but here are some tips: Check the format of all the three cells for strange settings, set the formats to "general". Try to multiply both cells with 1.
– Máté Juhász
May 21 '15 at 20:16
1
1
In addition to the suggestion by @MátéJuhász set the formats to Number. Most likely, at least one of the cells is formatted as text. For math operations, Excel treats text as
0.– Engineer Toast
May 21 '15 at 20:34
In addition to the suggestion by @MátéJuhász set the formats to Number. Most likely, at least one of the cells is formatted as text. For math operations, Excel treats text as
0.– Engineer Toast
May 21 '15 at 20:34
2
2
@YSilber, can you share the file on a file sharing site?
– teylyn
May 21 '15 at 20:51
@YSilber, can you share the file on a file sharing site?
– teylyn
May 21 '15 at 20:51
3
3
Try
=value(J2)*value(K2) . If this is correct, then one or both of the values is text. BTW, by default, text is left aligned; true numbers are right aligned.– Jeeped
May 22 '15 at 1:32
Try
=value(J2)*value(K2) . If this is correct, then one or both of the values is text. BTW, by default, text is left aligned; true numbers are right aligned.– Jeeped
May 22 '15 at 1:32
3
3
Make sure your system work with decimal point instead of comma. Maybe 16.32 should be 16,32.
– jcbermu
May 25 '15 at 9:30
Make sure your system work with decimal point instead of comma. Maybe 16.32 should be 16,32.
– jcbermu
May 25 '15 at 9:30
|
show 2 more comments
2 Answers
2
active
oldest
votes
Also check to see if you are creating a circular calculation. If Excel is already warning you of a circular calculation in another part of your spreadsheet, it won't directly warn you if you create another circular calculation. It may just give you a 0 result instead.
answered Sep 18 '18 at 12:44
ChrisChris
1
add a comment |
I was experiencing this too and the problem was that I was referring to the wrong cell. When you merge cells, a single cell can consist of multiple rows or columns. Make sure to use the far left column or the top row when you reference a merged cell.
answered 10 mins ago
Dylan SellersDylan Sellers
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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%2f917900%2fmultiplying-two-cells-returns-zero%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
Also check to see if you are creating a circular calculation. If Excel is already warning you of a circular calculation in another part of your spreadsheet, it won't directly warn you if you create another circular calculation. It may just give you a 0 result instead.
answered Sep 18 '18 at 12:44
ChrisChris
1
add a comment |
Also check to see if you are creating a circular calculation. If Excel is already warning you of a circular calculation in another part of your spreadsheet, it won't directly warn you if you create another circular calculation. It may just give you a 0 result instead.
answered Sep 18 '18 at 12:44
ChrisChris
1
add a comment |
Also check to see if you are creating a circular calculation. If Excel is already warning you of a circular calculation in another part of your spreadsheet, it won't directly warn you if you create another circular calculation. It may just give you a 0 result instead.
answered Sep 18 '18 at 12:44
ChrisChris
1
Also check to see if you are creating a circular calculation. If Excel is already warning you of a circular calculation in another part of your spreadsheet, it won't directly warn you if you create another circular calculation. It may just give you a 0 result instead.
answered Sep 18 '18 at 12:44
ChrisChris
1
answered Sep 18 '18 at 12:44
ChrisChris
1
answered Sep 18 '18 at 12:44
ChrisChris
1
answered Sep 18 '18 at 12:44
ChrisChris
1
1
add a comment |
add a comment |
I was experiencing this too and the problem was that I was referring to the wrong cell. When you merge cells, a single cell can consist of multiple rows or columns. Make sure to use the far left column or the top row when you reference a merged cell.
answered 10 mins ago
Dylan SellersDylan Sellers
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I was experiencing this too and the problem was that I was referring to the wrong cell. When you merge cells, a single cell can consist of multiple rows or columns. Make sure to use the far left column or the top row when you reference a merged cell.
answered 10 mins ago
Dylan SellersDylan Sellers
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I was experiencing this too and the problem was that I was referring to the wrong cell. When you merge cells, a single cell can consist of multiple rows or columns. Make sure to use the far left column or the top row when you reference a merged cell.
answered 10 mins ago
Dylan SellersDylan Sellers
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I was experiencing this too and the problem was that I was referring to the wrong cell. When you merge cells, a single cell can consist of multiple rows or columns. Make sure to use the far left column or the top row when you reference a merged cell.
answered 10 mins ago
Dylan SellersDylan Sellers
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 10 mins ago
Dylan SellersDylan Sellers
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 10 mins ago
Dylan SellersDylan Sellers
1
answered 10 mins ago
Dylan SellersDylan Sellers
1
1
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Dylan Sellers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
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%2f917900%2fmultiplying-two-cells-returns-zero%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
1
I don't know what is the problem, but here are some tips: Check the format of all the three cells for strange settings, set the formats to "general". Try to multiply both cells with 1.
– Máté Juhász
May 21 '15 at 20:16
1
In addition to the suggestion by @MátéJuhász set the formats to Number. Most likely, at least one of the cells is formatted as text. For math operations, Excel treats text as
0.– Engineer Toast
May 21 '15 at 20:34
2
@YSilber, can you share the file on a file sharing site?
– teylyn
May 21 '15 at 20:51
3
Try
=value(J2)*value(K2). If this is correct, then one or both of the values is text. BTW, by default, text is left aligned; true numbers are right aligned.– Jeeped
May 22 '15 at 1:32
3
Make sure your system work with decimal point instead of comma. Maybe 16.32 should be 16,32.
– jcbermu
May 25 '15 at 9:30