Complicated 'IF' function in Excel
In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status is blank, in which case I want column D to say "Due after PV."
I'm not sure how to do this - I need something like an IF, THEN, UNLESS statement, but I don't think anything like this exists. How can I make this formula?
Thank you
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
asked Jan 14 at 0:57
forlornforlorn
11
add a comment |
In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status is blank, in which case I want column D to say "Due after PV."
I'm not sure how to do this - I need something like an IF, THEN, UNLESS statement, but I don't think anything like this exists. How can I make this formula?
Thank you
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
asked Jan 14 at 0:57
forlornforlorn
11
add a comment |
In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status is blank, in which case I want column D to say "Due after PV."
I'm not sure how to do this - I need something like an IF, THEN, UNLESS statement, but I don't think anything like this exists. How can I make this formula?
Thank you
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
asked Jan 14 at 0:57
forlornforlorn
11
In Sheet 1, I have the following:
If the Due Date is after the Date Submitted, then I want the value in column D of this sheet to be the Detail Status, which is on Sheet 2,
UNLESS the Detail Status is blank, in which case I want column D to say "Due after PV."
I'm not sure how to do this - I need something like an IF, THEN, UNLESS statement, but I don't think anything like this exists. How can I make this formula?
Thank you
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
microsoft-excel worksheet-function microsoft-excel-2010 microsoft-excel-2013 microsoft-excel-2016
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
asked Jan 14 at 0:57
forlornforlorn
11
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
asked Jan 14 at 0:57
forlornforlorn
11
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
edited Jan 14 at 3:38
Ron Rosenfeld
1,9972611
1,9972611
asked Jan 14 at 0:57
forlornforlorn
11
asked Jan 14 at 0:57
forlornforlorn
11
asked Jan 14 at 0:57
forlornforlorn
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Perhaps a formatted formula will make the logic easier to follow:
=IF(B2>C2,
IF(VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)="","Due after PV",
VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)),
"")
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
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%2f1393931%2fcomplicated-if-function-in-excel%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
Perhaps a formatted formula will make the logic easier to follow:
=IF(B2>C2,
IF(VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)="","Due after PV",
VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)),
"")
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
add a comment |
Perhaps a formatted formula will make the logic easier to follow:
=IF(B2>C2,
IF(VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)="","Due after PV",
VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)),
"")
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
add a comment |
Perhaps a formatted formula will make the logic easier to follow:
=IF(B2>C2,
IF(VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)="","Due after PV",
VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)),
"")
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
Perhaps a formatted formula will make the logic easier to follow:
=IF(B2>C2,
IF(VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)="","Due after PV",
VLOOKUP(A2,Sheet2!$A$2:$B$6,2,FALSE)),
"")
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
answered Jan 14 at 3:12
Ron RosenfeldRon Rosenfeld
1,9972611
1,9972611
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%2f1393931%2fcomplicated-if-function-in-excel%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
