Excel IF and AND with 4 outputs2019 Community Moderator ElectionHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I properly clean up Excel interop objects?What is correct content-type for excel files?Excel to CSV with UTF8 encodingHow to avoid using Select in Excel VBAFunction if/elif/else syntax errorVBA Excel Show Values in MSGBOXExcel Macro VBA basic comparison - but unable to fix errorExcel 2013 VBA ThisWorkBook BeforeClose event not recognizing methodsDisplay column headers that have been filtered in Excel
Violin - Can double stops be played when the strings are not next to each other?
Why does overlay work only on the first tcolorbox?
How do I hide Chekhov's Gun?
Why does energy conservation give me the wrong answer in this inelastic collision problem?
Instead of a Universal Basic Income program, why not implement a "Universal Basic Needs" program?
What is the Japanese sound word for the clinking of money?
How should I state my peer review experience in the CV?
How are passwords stolen from companies if they only store hashes?
What is the significance behind "40 days" that often appears in the Bible?
New passport but visa is in old (lost) passport
Is it good practice to use Linear Least-Squares with SMA?
The German vowel “a” changes to the English “i”
Meme-controlled people
Is honey really a supersaturated solution? Does heating to un-crystalize redissolve it or melt it?
Is there a symmetric-key algorithm which we can use for creating a signature?
Happy pi day, everyone!
Knife as defense against stray dogs
Why is a white electrical wire connected to 2 black wires?
Do I need to be arrogant to get ahead?
Python if-else code style for reduced code for rounding floats
How to make healing in an exploration game interesting
How to deal with taxi scam when on vacation?
Most cost effective thermostat setting: consistent temperature vs. lowest temperature possible
How do you talk to someone whose loved one is dying?
Excel IF and AND with 4 outputs
2019 Community Moderator ElectionHow to create Excel (.XLS and .XLSX) file in C# without installing Ms Office?How do I properly clean up Excel interop objects?What is correct content-type for excel files?Excel to CSV with UTF8 encodingHow to avoid using Select in Excel VBAFunction if/elif/else syntax errorVBA Excel Show Values in MSGBOXExcel Macro VBA basic comparison - but unable to fix errorExcel 2013 VBA ThisWorkBook BeforeClose event not recognizing methodsDisplay column headers that have been filtered in Excel
I'm trying yo update an IF function but get an error highlighting "E41"
I have the following which works fine:
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")))
The new 4th condition is added below but gives an error:
(the text within the " and " is different but this isn't the cause of the problem!)
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
My four cases and the conditions are therefore:
If E31<B9 - display "d limits DF range"
If E41>B9 - display "L not limiting DF range"
If E41<B9 and (B9-E41)=<E36 and E31 >=B9 - display "Yes remainging d is sufficient"
New condition is to take into account extra option of
If E41<B9 and (B9-E41)>E36 then display "insufficient d once L runs out"
Any help most gratefully received! Trying to get the syntax understood still!
thanks!!!
excel if-statement
asked Mar 7 at 15:27
CasperCasper
82
add a comment |
I'm trying yo update an IF function but get an error highlighting "E41"
I have the following which works fine:
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")))
The new 4th condition is added below but gives an error:
(the text within the " and " is different but this isn't the cause of the problem!)
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
My four cases and the conditions are therefore:
If E31<B9 - display "d limits DF range"
If E41>B9 - display "L not limiting DF range"
If E41<B9 and (B9-E41)=<E36 and E31 >=B9 - display "Yes remainging d is sufficient"
New condition is to take into account extra option of
If E41<B9 and (B9-E41)>E36 then display "insufficient d once L runs out"
Any help most gratefully received! Trying to get the syntax understood still!
thanks!!!
excel if-statement
asked Mar 7 at 15:27
CasperCasper
82
add a comment |
I'm trying yo update an IF function but get an error highlighting "E41"
I have the following which works fine:
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")))
The new 4th condition is added below but gives an error:
(the text within the " and " is different but this isn't the cause of the problem!)
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
My four cases and the conditions are therefore:
If E31<B9 - display "d limits DF range"
If E41>B9 - display "L not limiting DF range"
If E41<B9 and (B9-E41)=<E36 and E31 >=B9 - display "Yes remainging d is sufficient"
New condition is to take into account extra option of
If E41<B9 and (B9-E41)>E36 then display "insufficient d once L runs out"
Any help most gratefully received! Trying to get the syntax understood still!
thanks!!!
excel if-statement
asked Mar 7 at 15:27
CasperCasper
82
I'm trying yo update an IF function but get an error highlighting "E41"
I have the following which works fine:
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")))
The new 4th condition is added below but gives an error:
(the text within the " and " is different but this isn't the cause of the problem!)
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
My four cases and the conditions are therefore:
If E31<B9 - display "d limits DF range"
If E41>B9 - display "L not limiting DF range"
If E41<B9 and (B9-E41)=<E36 and E31 >=B9 - display "Yes remainging d is sufficient"
New condition is to take into account extra option of
If E41<B9 and (B9-E41)>E36 then display "insufficient d once L runs out"
Any help most gratefully received! Trying to get the syntax understood still!
thanks!!!
excel if-statement
excel if-statement
asked Mar 7 at 15:27
CasperCasper
82
asked Mar 7 at 15:27
CasperCasper
82
asked Mar 7 at 15:27
CasperCasper
82
asked Mar 7 at 15:27
CasperCasper
82
asked Mar 7 at 15:27
CasperCasper
82
82
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Multiple Conditions Excel Formula
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
Compare
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
add a comment |
Try this:
=IF(AND(E41=B9),"Yes, remaining d is sufficient",IF(E31=B9,"L not limiting DF range",IF(B9-E41)>E36,"Insufficient d after L runs out","None is True"))))
Cheers
Tim
answered Mar 7 at 15:45
tisch84tisch84
13
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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%2fstackoverflow.com%2fquestions%2f55047358%2fexcel-if-and-and-with-4-outputs%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
Multiple Conditions Excel Formula
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
Compare
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
add a comment |
Multiple Conditions Excel Formula
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
Compare
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
add a comment |
Multiple Conditions Excel Formula
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
Compare
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
Multiple Conditions Excel Formula
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
Compare
=IF(AND(E41<B9,B9-E41<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range",IF(B9-E41>E36,"Insufficient d after L runs out"))))
=IF(AND(E41<B9,(B9-E41)<=E36,E31>=B9),"Yes, remaining d is sufficient",IF(E31<B9,"d limits DF range",IF(E41>=B9,"L not limiting DF range")),IF(B9-E41)>E36,"Insufficient d after L runs out"))
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
answered Mar 7 at 15:43
VBasic2008VBasic2008
3,3512517
3,3512517
add a comment |
add a comment |
Try this:
=IF(AND(E41=B9),"Yes, remaining d is sufficient",IF(E31=B9,"L not limiting DF range",IF(B9-E41)>E36,"Insufficient d after L runs out","None is True"))))
Cheers
Tim
answered Mar 7 at 15:45
tisch84tisch84
13
add a comment |
Try this:
=IF(AND(E41=B9),"Yes, remaining d is sufficient",IF(E31=B9,"L not limiting DF range",IF(B9-E41)>E36,"Insufficient d after L runs out","None is True"))))
Cheers
Tim
answered Mar 7 at 15:45
tisch84tisch84
13
add a comment |
Try this:
=IF(AND(E41=B9),"Yes, remaining d is sufficient",IF(E31=B9,"L not limiting DF range",IF(B9-E41)>E36,"Insufficient d after L runs out","None is True"))))
Cheers
Tim
answered Mar 7 at 15:45
tisch84tisch84
13
Try this:
=IF(AND(E41=B9),"Yes, remaining d is sufficient",IF(E31=B9,"L not limiting DF range",IF(B9-E41)>E36,"Insufficient d after L runs out","None is True"))))
Cheers
Tim
answered Mar 7 at 15:45
tisch84tisch84
13
edited Mar 7 at 15:46
answered Mar 7 at 15:45
tisch84tisch84
13
answered Mar 7 at 15:45
tisch84tisch84
13
answered Mar 7 at 15:45
tisch84tisch84
13
13
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- 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%2fstackoverflow.com%2fquestions%2f55047358%2fexcel-if-and-and-with-4-outputs%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
