Excel IF/THEN Conditions
0
I have a cell for shipping weights, and a cell for receiving weights. In a 3rd cell, I want to calculate the difference (receiving minus shipping), but only show that difference if it is more than 1,000 lbs (either positive or negative).
worksheet-function
edited Jan 2 at 21:38
agtoever
5,07911330
asked Jan 2 at 21:24
CinZinCinZin
11
add a comment |
0
I have a cell for shipping weights, and a cell for receiving weights. In a 3rd cell, I want to calculate the difference (receiving minus shipping), but only show that difference if it is more than 1,000 lbs (either positive or negative).
worksheet-function
edited Jan 2 at 21:38
agtoever
5,07911330
asked Jan 2 at 21:24
CinZinCinZin
11
Did you try anything?
– simlev
Jan 2 at 21:32
add a comment |
0
0
0
I have a cell for shipping weights, and a cell for receiving weights. In a 3rd cell, I want to calculate the difference (receiving minus shipping), but only show that difference if it is more than 1,000 lbs (either positive or negative).
worksheet-function
edited Jan 2 at 21:38
agtoever
5,07911330
asked Jan 2 at 21:24
CinZinCinZin
11
I have a cell for shipping weights, and a cell for receiving weights. In a 3rd cell, I want to calculate the difference (receiving minus shipping), but only show that difference if it is more than 1,000 lbs (either positive or negative).
worksheet-function
worksheet-function
edited Jan 2 at 21:38
agtoever
5,07911330
asked Jan 2 at 21:24
CinZinCinZin
11
edited Jan 2 at 21:38
agtoever
5,07911330
asked Jan 2 at 21:24
CinZinCinZin
11
edited Jan 2 at 21:38
agtoever
5,07911330
edited Jan 2 at 21:38
agtoever
5,07911330
edited Jan 2 at 21:38
agtoever
5,07911330
5,07911330
asked Jan 2 at 21:24
CinZinCinZin
11
asked Jan 2 at 21:24
CinZinCinZin
11
asked Jan 2 at 21:24
CinZinCinZin
11
11
Did you try anything?
– simlev
Jan 2 at 21:32
add a comment |
Did you try anything?
– simlev
Jan 2 at 21:32
Did you try anything?
– simlev
Jan 2 at 21:32
Did you try anything?
– simlev
Jan 2 at 21:32
add a comment |
1 Answer
1
active
oldest
votes
2
This will return either the Weight if over 1000lbs or 0:
=IF(ABS(A1-B1)>=1000,A1-B1,0)
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
1
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
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
});
}
});
draft saved
draft discarded
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%2f1389949%2fexcel-if-then-conditions%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
2
This will return either the Weight if over 1000lbs or 0:
=IF(ABS(A1-B1)>=1000,A1-B1,0)
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
1
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
add a comment |
2
This will return either the Weight if over 1000lbs or 0:
=IF(ABS(A1-B1)>=1000,A1-B1,0)
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
1
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
add a comment |
2
2
2
This will return either the Weight if over 1000lbs or 0:
=IF(ABS(A1-B1)>=1000,A1-B1,0)
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
This will return either the Weight if over 1000lbs or 0:
=IF(ABS(A1-B1)>=1000,A1-B1,0)
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
answered Jan 2 at 21:29
Scott CranerScott Craner
11.5k1815
11.5k1815
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
1
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
add a comment |
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
1
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
WHAT?? I've been looking at this thing all day, trying this and that and those... Amazing!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
What that really means is, THANK YOU!!
– CinZin
Jan 2 at 21:39
1
1
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
@CinZin if it worked please mark as correct by clicking the check mark by the answer.
– Scott Craner
Jan 2 at 21:46
add a comment |
draft saved
draft discarded
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.
draft saved
draft discarded
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%2f1389949%2fexcel-if-then-conditions%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
Did you try anything?
– simlev
Jan 2 at 21:32