Sum of two cells where one must be negative?Positive result, negative result and current balance. How do you...
Why is Collection not simply treated as Collection<?>
Emailing HOD to enhance faculty application
Is it canonical bit space?
Were any external disk drives stacked vertically?
Why is it a bad idea to hire a hitman to eliminate most corrupt politicians?
Intersection of two sorted vectors in C++
Why can't we play rap on piano?
What is the intuition behind short exact sequences of groups; in particular, what is the intuition behind group extensions?
Stopping power of mountain vs road bike
What about the virus in 12 Monkeys?
Where does SFDX store details about scratch orgs?
Is there a hemisphere-neutral way of specifying a season?
How to draw the figure with four pentagons?
Combinations of multiple lists
If human space travel is limited by the G force vulnerability, is there a way to counter G forces?
How much of data wrangling is a data scientist's job?
Can a virus destroy the BIOS of a modern computer?
Is it unprofessional to ask if a job posting on GlassDoor is real?
Memorizing the Keyboard
Anagram holiday
CEO ridiculed me with gay jokes and grabbed me and wouldn't let go - now getting pushed out of company
Why do I get two different answers for this counting problem?
A reference to a well-known characterization of scattered compact spaces
Today is the Center
Sum of two cells where one must be negative?
Positive result, negative result and current balance. How do you make starting balance show current result?Apply one formula to all selected cellsSubtract Two Cells. Result valueTrying to create a SUMIF or SUMPRODUCT with one positive criteria and one negative criteriaHow to change a negative value to a positive number not exceeding 49Excel Formula to subtract cells from one and other whilst ignoring textSum max consecutive cells if negativeSubtraction + modified result if negativeIn excel how can I sum all the cells above the current cell upto a particular cellExcel Multiplication error when multiplying two cells where one cell has a calculated value
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I need to add the product of one cell to another cell, but only if the second cell is a negative number. The product of the first cell is a result of another formula and is always positive. The product of the second cell may be either positive or negative but only added if a negative number is produced?
microsoft-excel worksheet-function
asked 10 hours ago
DavidDavid
1
New contributor
David 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 need to add the product of one cell to another cell, but only if the second cell is a negative number. The product of the first cell is a result of another formula and is always positive. The product of the second cell may be either positive or negative but only added if a negative number is produced?
microsoft-excel worksheet-function
asked 10 hours ago
DavidDavid
1
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
what do you want to return if it is not negative?
– Scott Craner
10 hours ago
Do you want to use if?
– Leonardo Alves Machado
10 hours ago
A blank cell, if possible.
– David
10 hours ago
See edited answer below
– Scott Craner
9 hours ago
add a comment |
I need to add the product of one cell to another cell, but only if the second cell is a negative number. The product of the first cell is a result of another formula and is always positive. The product of the second cell may be either positive or negative but only added if a negative number is produced?
microsoft-excel worksheet-function
asked 10 hours ago
DavidDavid
1
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I need to add the product of one cell to another cell, but only if the second cell is a negative number. The product of the first cell is a result of another formula and is always positive. The product of the second cell may be either positive or negative but only added if a negative number is produced?
microsoft-excel worksheet-function
microsoft-excel worksheet-function
asked 10 hours ago
DavidDavid
1
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 10 hours ago
DavidDavid
1
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 10 hours ago
DavidDavid
1
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 10 hours ago
DavidDavid
1
asked 10 hours ago
DavidDavid
1
1
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
David is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
what do you want to return if it is not negative?
– Scott Craner
10 hours ago
Do you want to use if?
– Leonardo Alves Machado
10 hours ago
A blank cell, if possible.
– David
10 hours ago
See edited answer below
– Scott Craner
9 hours ago
add a comment |
what do you want to return if it is not negative?
– Scott Craner
10 hours ago
Do you want to use if?
– Leonardo Alves Machado
10 hours ago
A blank cell, if possible.
– David
10 hours ago
See edited answer below
– Scott Craner
9 hours ago
what do you want to return if it is not negative?
– Scott Craner
10 hours ago
what do you want to return if it is not negative?
– Scott Craner
10 hours ago
Do you want to use if?
– Leonardo Alves Machado
10 hours ago
Do you want to use if?
– Leonardo Alves Machado
10 hours ago
A blank cell, if possible.
– David
10 hours ago
A blank cell, if possible.
– David
10 hours ago
See edited answer below
– Scott Craner
9 hours ago
See edited answer below
– Scott Craner
9 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Use a standard IF()
=IF(B1<0,A1+B1,"")
Where A1 contains the product of your first formula and B1 the product of the second.
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
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
});
}
});
David is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1421540%2fsum-of-two-cells-where-one-must-be-negative%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
Use a standard IF()
=IF(B1<0,A1+B1,"")
Where A1 contains the product of your first formula and B1 the product of the second.
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
add a comment |
Use a standard IF()
=IF(B1<0,A1+B1,"")
Where A1 contains the product of your first formula and B1 the product of the second.
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
add a comment |
Use a standard IF()
=IF(B1<0,A1+B1,"")
Where A1 contains the product of your first formula and B1 the product of the second.
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
Use a standard IF()
=IF(B1<0,A1+B1,"")
Where A1 contains the product of your first formula and B1 the product of the second.
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
edited 9 hours ago
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
answered 10 hours ago
Scott CranerScott Craner
12.5k11318
12.5k11318
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
add a comment |
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
Some versions of Excel uses ";" instead of "," as the separator (like my swedish version).
– Ola Ström
9 hours ago
add a comment |
David is a new contributor. Be nice, and check out our Code of Conduct.
David is a new contributor. Be nice, and check out our Code of Conduct.
David is a new contributor. Be nice, and check out our Code of Conduct.
David is a new contributor. Be nice, and check out our Code of Conduct.
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%2f1421540%2fsum-of-two-cells-where-one-must-be-negative%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 do you want to return if it is not negative?
– Scott Craner
10 hours ago
Do you want to use if?
– Leonardo Alves Machado
10 hours ago
A blank cell, if possible.
– David
10 hours ago
See edited answer below
– Scott Craner
9 hours ago