I have an If/or/and statement in three columns and the third column is not calculating at all
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
0
The formatting is general. I have copied and repasted the formula.
=IF(OR(AND($B$9="Boise",[Duty Station]="Marsing"), (AND($B$9="Boise",[Duty Station]="Boise")), (AND($B$9="Twin Falls",[Duty Station]="Burley")), (AND($B$9="Twin Falls", [Duty Station]="Shoshone")), (AND($B$9="Twin Falls", [Duty Station]="Twin Falls")),(AND($B$9="Coeur d'Alene",[Duty Station]="Coeur d'Alene")), (AND($B$9="Pocatello",[Duty Station]="Pocatello")),(AND($B$9="Idaho Falls",[Duty Station]="Idaho Falls"))),0,SUM($E$5))
microsoft-excel
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
asked Mar 6 at 15:31
ZoeZoe
71
|
show 1 more comment
0
The formatting is general. I have copied and repasted the formula.
=IF(OR(AND($B$9="Boise",[Duty Station]="Marsing"), (AND($B$9="Boise",[Duty Station]="Boise")), (AND($B$9="Twin Falls",[Duty Station]="Burley")), (AND($B$9="Twin Falls", [Duty Station]="Shoshone")), (AND($B$9="Twin Falls", [Duty Station]="Twin Falls")),(AND($B$9="Coeur d'Alene",[Duty Station]="Coeur d'Alene")), (AND($B$9="Pocatello",[Duty Station]="Pocatello")),(AND($B$9="Idaho Falls",[Duty Station]="Idaho Falls"))),0,SUM($E$5))
microsoft-excel
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
asked Mar 6 at 15:31
ZoeZoe
71
2
Can you give us sample data and expected outcome?
– cybernetic.nomad
Mar 6 at 15:36
What are you trying to do? Just showing a formula with a very broad title makes it hard to understand what you'd like the results to be. Can you please also provide a short background statement?
– BruceWayne
Mar 6 at 15:52
Are your calculation on automatic or manual?
– Scott Craner
Mar 6 at 15:53
Hello we are doing a cost comparison between 3 cities, this is the formula that is used in the first two comparisons with the exception of the reference at the end to $E$5 - which is the meeting city. It is as if the column is frozen and will not calculate.
– Zoe
Mar 6 at 21:00
Calculations are automatic. I even went in and told it to calculate.
– Zoe
Mar 6 at 21:00
|
show 1 more comment
0
0
0
The formatting is general. I have copied and repasted the formula.
=IF(OR(AND($B$9="Boise",[Duty Station]="Marsing"), (AND($B$9="Boise",[Duty Station]="Boise")), (AND($B$9="Twin Falls",[Duty Station]="Burley")), (AND($B$9="Twin Falls", [Duty Station]="Shoshone")), (AND($B$9="Twin Falls", [Duty Station]="Twin Falls")),(AND($B$9="Coeur d'Alene",[Duty Station]="Coeur d'Alene")), (AND($B$9="Pocatello",[Duty Station]="Pocatello")),(AND($B$9="Idaho Falls",[Duty Station]="Idaho Falls"))),0,SUM($E$5))
microsoft-excel
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
asked Mar 6 at 15:31
ZoeZoe
71
The formatting is general. I have copied and repasted the formula.
=IF(OR(AND($B$9="Boise",[Duty Station]="Marsing"), (AND($B$9="Boise",[Duty Station]="Boise")), (AND($B$9="Twin Falls",[Duty Station]="Burley")), (AND($B$9="Twin Falls", [Duty Station]="Shoshone")), (AND($B$9="Twin Falls", [Duty Station]="Twin Falls")),(AND($B$9="Coeur d'Alene",[Duty Station]="Coeur d'Alene")), (AND($B$9="Pocatello",[Duty Station]="Pocatello")),(AND($B$9="Idaho Falls",[Duty Station]="Idaho Falls"))),0,SUM($E$5))
microsoft-excel
microsoft-excel
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
asked Mar 6 at 15:31
ZoeZoe
71
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
asked Mar 6 at 15:31
ZoeZoe
71
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
edited Mar 6 at 15:35
cybernetic.nomad
2,686617
2,686617
asked Mar 6 at 15:31
ZoeZoe
71
asked Mar 6 at 15:31
ZoeZoe
71
asked Mar 6 at 15:31
ZoeZoe
71
71
2
Can you give us sample data and expected outcome?
– cybernetic.nomad
Mar 6 at 15:36
What are you trying to do? Just showing a formula with a very broad title makes it hard to understand what you'd like the results to be. Can you please also provide a short background statement?
– BruceWayne
Mar 6 at 15:52
Are your calculation on automatic or manual?
– Scott Craner
Mar 6 at 15:53
Hello we are doing a cost comparison between 3 cities, this is the formula that is used in the first two comparisons with the exception of the reference at the end to $E$5 - which is the meeting city. It is as if the column is frozen and will not calculate.
– Zoe
Mar 6 at 21:00
Calculations are automatic. I even went in and told it to calculate.
– Zoe
Mar 6 at 21:00
|
show 1 more comment
2
Can you give us sample data and expected outcome?
– cybernetic.nomad
Mar 6 at 15:36
What are you trying to do? Just showing a formula with a very broad title makes it hard to understand what you'd like the results to be. Can you please also provide a short background statement?
– BruceWayne
Mar 6 at 15:52
Are your calculation on automatic or manual?
– Scott Craner
Mar 6 at 15:53
Hello we are doing a cost comparison between 3 cities, this is the formula that is used in the first two comparisons with the exception of the reference at the end to $E$5 - which is the meeting city. It is as if the column is frozen and will not calculate.
– Zoe
Mar 6 at 21:00
Calculations are automatic. I even went in and told it to calculate.
– Zoe
Mar 6 at 21:00
2
2
Can you give us sample data and expected outcome?
– cybernetic.nomad
Mar 6 at 15:36
Can you give us sample data and expected outcome?
– cybernetic.nomad
Mar 6 at 15:36
What are you trying to do? Just showing a formula with a very broad title makes it hard to understand what you'd like the results to be. Can you please also provide a short background statement?
– BruceWayne
Mar 6 at 15:52
What are you trying to do? Just showing a formula with a very broad title makes it hard to understand what you'd like the results to be. Can you please also provide a short background statement?
– BruceWayne
Mar 6 at 15:52
Are your calculation on automatic or manual?
– Scott Craner
Mar 6 at 15:53
Are your calculation on automatic or manual?
– Scott Craner
Mar 6 at 15:53
Hello we are doing a cost comparison between 3 cities, this is the formula that is used in the first two comparisons with the exception of the reference at the end to $E$5 - which is the meeting city. It is as if the column is frozen and will not calculate.
– Zoe
Mar 6 at 21:00
Hello we are doing a cost comparison between 3 cities, this is the formula that is used in the first two comparisons with the exception of the reference at the end to $E$5 - which is the meeting city. It is as if the column is frozen and will not calculate.
– Zoe
Mar 6 at 21:00
Calculations are automatic. I even went in and told it to calculate.
– Zoe
Mar 6 at 21:00
Calculations are automatic. I even went in and told it to calculate.
– Zoe
Mar 6 at 21:00
|
show 1 more comment
0
active
oldest
votes
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%2f1411834%2fi-have-an-if-or-and-statement-in-three-columns-and-the-third-column-is-not-calcu%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
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%2f1411834%2fi-have-an-if-or-and-statement-in-three-columns-and-the-third-column-is-not-calcu%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
2
Can you give us sample data and expected outcome?
– cybernetic.nomad
Mar 6 at 15:36
What are you trying to do? Just showing a formula with a very broad title makes it hard to understand what you'd like the results to be. Can you please also provide a short background statement?
– BruceWayne
Mar 6 at 15:52
Are your calculation on automatic or manual?
– Scott Craner
Mar 6 at 15:53
Hello we are doing a cost comparison between 3 cities, this is the formula that is used in the first two comparisons with the exception of the reference at the end to $E$5 - which is the meeting city. It is as if the column is frozen and will not calculate.
– Zoe
Mar 6 at 21:00
Calculations are automatic. I even went in and told it to calculate.
– Zoe
Mar 6 at 21:00