Nested IF and AND Statement for a rangeExcel - Extended IF / ELSE StatementNested IF statementIf statement...
How does a sound wave propagate?
Is divide-by-zero a security vulnerability?
What is the oldest European royal house?
Mixed Feelings - What am I
Why does this boat have a landing pad? (SpaceX's GO Searcher) Any plans for propulsive capsule landings?
What is better: yes / no radio, or simple checkbox?
Is "cogitate" used appropriately in "I cogitate that success relies on hard work"?
After Brexit, will the EU recognize British passports that are valid for more than ten years?
ESPP--any reason not to go all in?
Professor forcing me to attend a conference, I can't afford even with 50% funding
How to install "rounded" brake pads
Boss Telling direct supervisor I snitched
What can I do if someone tampers with my SSH public key?
Ultrafilters as a double dual
Who has more? Ireland or Iceland?
Will the concrete slab in a partially heated shed conduct a lot of heat to the unconditioned area?
Use Mercury as quenching liquid for swords?
Why would /etc/passwd be used every time someone executes `ls -l` command?
What do you call someone who likes to pick fights?
Why does a car's steering wheel get lighter with increasing speed
Why is there an extra space when I type "ls" on the Desktop?
School performs periodic password audits. Is my password compromised?
Insult for someone who "doesn't know anything"
Can the Witch Sight warlock invocation see through the Mirror Image spell?
Nested IF and AND Statement for a range
Excel - Extended IF / ELSE StatementNested IF statementIf statement conditionsCOUNTIFS Statement Between DatesIf statement in excel 2007Nested IF statement only working when outside IF changesExcel Nested IF queryFormula-based conditional formatting to format cells in the same rowIf statement over columnTrouble using IFERROR with an IF statement that has Multiple Conditions
Here's what I'm trying to accomplish:
I have a cell, U5 which has a value between 2-18 ...
If U5 < 6, assign a 1
If U5 is >5 but <9, assign a 3
If V5 is >8 but <15, assign a 6
If V5 is >14, assign a 9
Trying to do this with a nested IF statement that I believe will require "AND" clauses.
Thanks!
microsoft-excel conditional-statements
asked 10 hours ago
JoshJosh
1
New contributor
Josh 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 |
Here's what I'm trying to accomplish:
I have a cell, U5 which has a value between 2-18 ...
If U5 < 6, assign a 1
If U5 is >5 but <9, assign a 3
If V5 is >8 but <15, assign a 6
If V5 is >14, assign a 9
Trying to do this with a nested IF statement that I believe will require "AND" clauses.
Thanks!
microsoft-excel conditional-statements
asked 10 hours ago
JoshJosh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you please edit your question to show us the formula you have tried?
– cybernetic.nomad
10 hours ago
add a comment |
Here's what I'm trying to accomplish:
I have a cell, U5 which has a value between 2-18 ...
If U5 < 6, assign a 1
If U5 is >5 but <9, assign a 3
If V5 is >8 but <15, assign a 6
If V5 is >14, assign a 9
Trying to do this with a nested IF statement that I believe will require "AND" clauses.
Thanks!
microsoft-excel conditional-statements
asked 10 hours ago
JoshJosh
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Here's what I'm trying to accomplish:
I have a cell, U5 which has a value between 2-18 ...
If U5 < 6, assign a 1
If U5 is >5 but <9, assign a 3
If V5 is >8 but <15, assign a 6
If V5 is >14, assign a 9
Trying to do this with a nested IF statement that I believe will require "AND" clauses.
Thanks!
microsoft-excel conditional-statements
microsoft-excel conditional-statements
asked 10 hours ago
JoshJosh
1
New contributor
Josh 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
JoshJosh
1
New contributor
Josh 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
JoshJosh
1
New contributor
Josh 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
JoshJosh
1
asked 10 hours ago
JoshJosh
1
1
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Josh is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Can you please edit your question to show us the formula you have tried?
– cybernetic.nomad
10 hours ago
add a comment |
Can you please edit your question to show us the formula you have tried?
– cybernetic.nomad
10 hours ago
Can you please edit your question to show us the formula you have tried?
– cybernetic.nomad
10 hours ago
Can you please edit your question to show us the formula you have tried?
– cybernetic.nomad
10 hours ago
add a comment |
1 Answer
1
active
oldest
votes
There are two ways you can do this:
with nested IFs:
=IF(F3<6,1,IF(F3<9,3,IF(F3<15,6,9)))
(No need for ANDs)
Or using INDEX/MATCH:
=INDEX({1,3,6,9},MATCH(F3,{0,6,9,15},1))
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
3
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nestedIF(), but not withMATCH()unless you add another table.
– AFH
10 hours ago
1
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 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
});
}
});
Josh 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%2f1412500%2fnested-if-and-and-statement-for-a-range%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
There are two ways you can do this:
with nested IFs:
=IF(F3<6,1,IF(F3<9,3,IF(F3<15,6,9)))
(No need for ANDs)
Or using INDEX/MATCH:
=INDEX({1,3,6,9},MATCH(F3,{0,6,9,15},1))
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
3
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nestedIF(), but not withMATCH()unless you add another table.
– AFH
10 hours ago
1
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 hours ago
add a comment |
There are two ways you can do this:
with nested IFs:
=IF(F3<6,1,IF(F3<9,3,IF(F3<15,6,9)))
(No need for ANDs)
Or using INDEX/MATCH:
=INDEX({1,3,6,9},MATCH(F3,{0,6,9,15},1))
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
3
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nestedIF(), but not withMATCH()unless you add another table.
– AFH
10 hours ago
1
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 hours ago
add a comment |
There are two ways you can do this:
with nested IFs:
=IF(F3<6,1,IF(F3<9,3,IF(F3<15,6,9)))
(No need for ANDs)
Or using INDEX/MATCH:
=INDEX({1,3,6,9},MATCH(F3,{0,6,9,15},1))
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
There are two ways you can do this:
with nested IFs:
=IF(F3<6,1,IF(F3<9,3,IF(F3<15,6,9)))
(No need for ANDs)
Or using INDEX/MATCH:
=INDEX({1,3,6,9},MATCH(F3,{0,6,9,15},1))
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
edited 10 hours ago
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
answered 10 hours ago
cybernetic.nomadcybernetic.nomad
2,273417
2,273417
3
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nestedIF(), but not withMATCH()unless you add another table.
– AFH
10 hours ago
1
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 hours ago
add a comment |
3
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nestedIF(), but not withMATCH()unless you add another table.
– AFH
10 hours ago
1
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 hours ago
3
3
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nested
IF(), but not with MATCH() unless you add another table.– AFH
10 hours ago
Very good, but the returned values are not [1,2,3,4], but [1,3,6,9]. This is easy with your nested
IF(), but not with MATCH() unless you add another table.– AFH
10 hours ago
1
1
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
@AFH - you,re right, I got distracted and just used 1,2,3,4 instead of 1,3,6,9. See edit to my answer
– cybernetic.nomad
10 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 hours ago
THANK YOU VERY MUCH! That was extremely helpful!
– Josh
8 hours ago
add a comment |
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Josh is a new contributor. Be nice, and check out our Code of Conduct.
Josh 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%2f1412500%2fnested-if-and-and-statement-for-a-range%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
Can you please edit your question to show us the formula you have tried?
– cybernetic.nomad
10 hours ago