Excel formulae for priority sectionsMs Excel Formulas for Date and DayExcel formula for tracking tasks and...
What is this cable/device?
What does chmod -u do?
Start making guitar arrangements
Are the IPv6 address space and IPv4 address space completely disjoint?
250 Floor Tower
Why electric field inside a cavity of a non-conducting sphere not zero?
Drawing ramified coverings with tikz
What is this called? Old film camera viewer?
How could a planet have erratic days?
What does routing an IP address mean?
Removing files under particular conditions (number of files, file age)
"Spoil" vs "Ruin"
How to bake one texture for one mesh with multiple textures blender 2.8
Biological Blimps: Propulsion
If a character has darkvision, can they see through an area of nonmagical darkness filled with lightly obscuring gas?
How do I find all files that end with a dot
Redundant comparison & "if" before assignment
Is there a working SACD iso player for Ubuntu?
What if a revenant (monster) gains fire resistance?
C++ debug/print custom type with GDB : the case of nlohmann json library
Is it possible to have a strip of cold climate in the middle of a planet?
Fear of getting stuck on one programming language / technology that is not used in my country
Aragorn's "guise" in the Orthanc Stone
What are the purposes of autoencoders?
Excel formulae for priority sections
Ms Excel Formulas for Date and DayExcel formula for tracking tasks and workload on two tabsReturn day number in year from date in Exceldate calcutation in excel based on other datesDate formula in excel regarding calendarExcel formula for auto fill a dateExcel Complicated SortSophisticated dates sorting in MS Excel?Multiple date formats in single column in excelExcel 2016 Pivot Table Column rename
I would like to add the date C6 to E6 (if P1=30 days, if P2=60 days, if P3=90 days, if P4=1 year) and show total in I6
windows-10 worksheet-function microsoft-excel-2016 date
edited 15 mins ago
Scott
16.1k113990
asked Nov 19 '18 at 15:29
JezJez
11
add a comment |
I would like to add the date C6 to E6 (if P1=30 days, if P2=60 days, if P3=90 days, if P4=1 year) and show total in I6
windows-10 worksheet-function microsoft-excel-2016 date
edited 15 mins ago
Scott
16.1k113990
asked Nov 19 '18 at 15:29
JezJez
11
add a comment |
I would like to add the date C6 to E6 (if P1=30 days, if P2=60 days, if P3=90 days, if P4=1 year) and show total in I6
windows-10 worksheet-function microsoft-excel-2016 date
edited 15 mins ago
Scott
16.1k113990
asked Nov 19 '18 at 15:29
JezJez
11
I would like to add the date C6 to E6 (if P1=30 days, if P2=60 days, if P3=90 days, if P4=1 year) and show total in I6
windows-10 worksheet-function microsoft-excel-2016 date
windows-10 worksheet-function microsoft-excel-2016 date
edited 15 mins ago
Scott
16.1k113990
asked Nov 19 '18 at 15:29
JezJez
11
edited 15 mins ago
Scott
16.1k113990
asked Nov 19 '18 at 15:29
JezJez
11
edited 15 mins ago
Scott
16.1k113990
edited 15 mins ago
Scott
16.1k113990
edited 15 mins ago
Scott
16.1k113990
16.1k113990
asked Nov 19 '18 at 15:29
JezJez
11
asked Nov 19 '18 at 15:29
JezJez
11
asked Nov 19 '18 at 15:29
JezJez
11
11
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You really need a switchcase which can be emulated by bunch of nested ifs
=IF(E6="P1";C6+30;IF(E6="P2";C6+60;IF(E6="P3";C6+90;If(E6="P4";C6+365;"No case specified"))))
I have hardcoded the dates to be added, what you can do is to add them to a column and reference them in the formula.
Cheers.
answered Nov 19 '18 at 15:58
dmbdmb
794312
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
1
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
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%2f1376718%2fexcel-formulae-for-priority-sections%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
You really need a switchcase which can be emulated by bunch of nested ifs
=IF(E6="P1";C6+30;IF(E6="P2";C6+60;IF(E6="P3";C6+90;If(E6="P4";C6+365;"No case specified"))))
I have hardcoded the dates to be added, what you can do is to add them to a column and reference them in the formula.
Cheers.
answered Nov 19 '18 at 15:58
dmbdmb
794312
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
1
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
add a comment |
You really need a switchcase which can be emulated by bunch of nested ifs
=IF(E6="P1";C6+30;IF(E6="P2";C6+60;IF(E6="P3";C6+90;If(E6="P4";C6+365;"No case specified"))))
I have hardcoded the dates to be added, what you can do is to add them to a column and reference them in the formula.
Cheers.
answered Nov 19 '18 at 15:58
dmbdmb
794312
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
1
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
add a comment |
You really need a switchcase which can be emulated by bunch of nested ifs
=IF(E6="P1";C6+30;IF(E6="P2";C6+60;IF(E6="P3";C6+90;If(E6="P4";C6+365;"No case specified"))))
I have hardcoded the dates to be added, what you can do is to add them to a column and reference them in the formula.
Cheers.
answered Nov 19 '18 at 15:58
dmbdmb
794312
You really need a switchcase which can be emulated by bunch of nested ifs
=IF(E6="P1";C6+30;IF(E6="P2";C6+60;IF(E6="P3";C6+90;If(E6="P4";C6+365;"No case specified"))))
I have hardcoded the dates to be added, what you can do is to add them to a column and reference them in the formula.
Cheers.
answered Nov 19 '18 at 15:58
dmbdmb
794312
edited Nov 19 '18 at 19:38
answered Nov 19 '18 at 15:58
dmbdmb
794312
answered Nov 19 '18 at 15:58
dmbdmb
794312
answered Nov 19 '18 at 15:58
dmbdmb
794312
794312
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
1
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
add a comment |
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
1
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
i have added this but it doesnt seem to work. Please note that i am a novice and not used excel much.
– Jez
Nov 22 '18 at 15:09
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
@Jez Ok, but be more specific, What doesn't work? Did you made sure that dates, are indeed dates and not strings? The data in E6, is it on like "P1" or can it have more charactes? I've tested this formula, with data like the onde presented. You need to copy this formula in the cell you need the info to be shown
– dmb
Nov 22 '18 at 15:22
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
The dates are "Dates" when you select "Format Cell" and click on dates. In regards to P1 etc all there will be in that cell will be P1, P2, P3 or P4.
– Jez
Nov 26 '18 at 14:32
1
1
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
@Jez Please expand on what have you tried till now. Also, tell us what's the error excel is thowing at you. Even though people on SuperUser knows a lot of stuff, we can't be lead to a guess game where we give information and you just say "it's not working" in hopes someone would figure out your problem.
– dmb
Nov 26 '18 at 14:43
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%2f1376718%2fexcel-formulae-for-priority-sections%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
