Please Fix my Formula for Microsoft ExcelMicrosoft Excel Price FormulaHow do I count # of rows in an array...
What is the word for reserving something for yourself before others do?
Could an aircraft fly or hover using only jets of compressed air?
How to efficiently unroll a matrix by value with numpy?
Why do I get two different answers for this counting problem?
Important Resources for Dark Age Civilizations?
Is it possible to run Internet Explorer on OS X El Capitan?
When a company launches a new product do they "come out" with a new product or do they "come up" with a new product?
Do I have a twin with permutated remainders?
Do infinite dimensional systems make sense?
Why doesn't Newton's third law mean a person bounces back to where they started when they hit the ground?
What typically incentivizes a professor to change jobs to a lower ranking university?
Modeling an IP Address
tikz convert color string to hex value
Does an object always see its latest internal state irrespective of thread?
Can I ask the recruiters in my resume to put the reason why I am rejected?
A newer friend of my brother's gave him a load of baseball cards that are supposedly extremely valuable. Is this a scam?
I'm flying to France today and my passport expires in less than 2 months
How is it possible to have an ability score that is less than 3?
What are these boxed doors outside store fronts in New York?
Why can't I see bouncing of a switch on an oscilloscope?
How to draw a waving flag in TikZ
Which country benefited the most from UN Security Council vetoes?
Languages that we cannot (dis)prove to be Context-Free
If human space travel is limited by the G force vulnerability, is there a way to counter G forces?
Please Fix my Formula for Microsoft Excel
Microsoft Excel Price FormulaHow do I count # of rows in an array ONLY IF the sum of numbers for each row is >0 in Excel?Microsoft Excel - Formula queryFormula issue Microsoft ExcelMicrosoft excel - formula draggingComplex Excel formula HELP pleaseMicrosoft Excel vlookup formulaMicrosoft Excel FormulaMicrosoft Excel Percentage FormulaMicrosoft Excel Formula 2013
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I've Tried this formula "={(D3+D4+D5)-4}/8-F3-F4"
But the answer keeps coming up one more than is truly accurate
What I need to have my equation calculate is... (Cell Values - Actual Data)
The Sum of Cells: D3(3.5),D4(24.0),D5(3.75)
The Sum needs to have 4 Taken off it (27.25)
That Value Needs to be Divided By 8 (3.40625)
Then I want Cells F3(0.00) and F4(3.0) Subtracted from it...
IF Possible... Rounded to the closest whole number
Doing the Calculation Manually is obviously not my issue - But my Spreadsheet has Multiple Similar Calculations - And I was hoping to have/use a Formula to work them out for me...
Thanks!
microsoft-excel microsoft
asked 22 hours ago
Gail SabourinGail Sabourin
12
New contributor
Gail Sabourin 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 |
I've Tried this formula "={(D3+D4+D5)-4}/8-F3-F4"
But the answer keeps coming up one more than is truly accurate
What I need to have my equation calculate is... (Cell Values - Actual Data)
The Sum of Cells: D3(3.5),D4(24.0),D5(3.75)
The Sum needs to have 4 Taken off it (27.25)
That Value Needs to be Divided By 8 (3.40625)
Then I want Cells F3(0.00) and F4(3.0) Subtracted from it...
IF Possible... Rounded to the closest whole number
Doing the Calculation Manually is obviously not my issue - But my Spreadsheet has Multiple Similar Calculations - And I was hoping to have/use a Formula to work them out for me...
Thanks!
microsoft-excel microsoft
asked 22 hours ago
Gail SabourinGail Sabourin
12
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4
Better you share sample data along with expected result, will help us to test data and fit it !!
– Rajesh S
22 hours ago
add a comment |
I've Tried this formula "={(D3+D4+D5)-4}/8-F3-F4"
But the answer keeps coming up one more than is truly accurate
What I need to have my equation calculate is... (Cell Values - Actual Data)
The Sum of Cells: D3(3.5),D4(24.0),D5(3.75)
The Sum needs to have 4 Taken off it (27.25)
That Value Needs to be Divided By 8 (3.40625)
Then I want Cells F3(0.00) and F4(3.0) Subtracted from it...
IF Possible... Rounded to the closest whole number
Doing the Calculation Manually is obviously not my issue - But my Spreadsheet has Multiple Similar Calculations - And I was hoping to have/use a Formula to work them out for me...
Thanks!
microsoft-excel microsoft
asked 22 hours ago
Gail SabourinGail Sabourin
12
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I've Tried this formula "={(D3+D4+D5)-4}/8-F3-F4"
But the answer keeps coming up one more than is truly accurate
What I need to have my equation calculate is... (Cell Values - Actual Data)
The Sum of Cells: D3(3.5),D4(24.0),D5(3.75)
The Sum needs to have 4 Taken off it (27.25)
That Value Needs to be Divided By 8 (3.40625)
Then I want Cells F3(0.00) and F4(3.0) Subtracted from it...
IF Possible... Rounded to the closest whole number
Doing the Calculation Manually is obviously not my issue - But my Spreadsheet has Multiple Similar Calculations - And I was hoping to have/use a Formula to work them out for me...
Thanks!
microsoft-excel microsoft
microsoft-excel microsoft
asked 22 hours ago
Gail SabourinGail Sabourin
12
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 hours ago
Gail SabourinGail Sabourin
12
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
edited 16 hours ago
Gail Sabourin
asked 22 hours ago
Gail SabourinGail Sabourin
12
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 22 hours ago
Gail SabourinGail Sabourin
12
asked 22 hours ago
Gail SabourinGail Sabourin
12
12
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Gail Sabourin is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
4
Better you share sample data along with expected result, will help us to test data and fit it !!
– Rajesh S
22 hours ago
add a comment |
4
Better you share sample data along with expected result, will help us to test data and fit it !!
– Rajesh S
22 hours ago
4
4
Better you share sample data along with expected result, will help us to test data and fit it !!
– Rajesh S
22 hours ago
Better you share sample data along with expected result, will help us to test data and fit it !!
– Rajesh S
22 hours ago
add a comment |
3 Answers
3
active
oldest
votes
The inner brackets are useless as you only subtract by 4 afterwards.
If you want to round, well use the function "round". If you want the closest full number, then round with ";0" at the end of the function. Besides that, your formula looks fine.
answered 21 hours ago
padawan_ITpadawan_IT
283
add a comment |
Try this:
=ROUND(((D3+D4+D5-4)/8)-F3-F4,0)
answered 17 hours ago
user2800user2800
1419
add a comment |
I don't do Excel so idk their syntax, but brackets are your friend..
(((D3+D4+D5)-4)/8)-F3-F4 would remove ambiguity, even though it's slight overkill.
Maths operators will tend to do multiplication & division first; humans tend to do it in the order they read it [unless they're mathematicians;)
answered 21 hours ago
TetsujinTetsujin
15.9k53462
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
});
}
});
Gail Sabourin 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%2f1421748%2fplease-fix-my-formula-for-microsoft-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
3 Answers
3
active
oldest
votes
3 Answers
3
active
oldest
votes
active
oldest
votes
active
oldest
votes
The inner brackets are useless as you only subtract by 4 afterwards.
If you want to round, well use the function "round". If you want the closest full number, then round with ";0" at the end of the function. Besides that, your formula looks fine.
answered 21 hours ago
padawan_ITpadawan_IT
283
add a comment |
The inner brackets are useless as you only subtract by 4 afterwards.
If you want to round, well use the function "round". If you want the closest full number, then round with ";0" at the end of the function. Besides that, your formula looks fine.
answered 21 hours ago
padawan_ITpadawan_IT
283
add a comment |
The inner brackets are useless as you only subtract by 4 afterwards.
If you want to round, well use the function "round". If you want the closest full number, then round with ";0" at the end of the function. Besides that, your formula looks fine.
answered 21 hours ago
padawan_ITpadawan_IT
283
The inner brackets are useless as you only subtract by 4 afterwards.
If you want to round, well use the function "round". If you want the closest full number, then round with ";0" at the end of the function. Besides that, your formula looks fine.
answered 21 hours ago
padawan_ITpadawan_IT
283
answered 21 hours ago
padawan_ITpadawan_IT
283
answered 21 hours ago
padawan_ITpadawan_IT
283
answered 21 hours ago
padawan_ITpadawan_IT
283
283
add a comment |
add a comment |
Try this:
=ROUND(((D3+D4+D5-4)/8)-F3-F4,0)
answered 17 hours ago
user2800user2800
1419
add a comment |
Try this:
=ROUND(((D3+D4+D5-4)/8)-F3-F4,0)
answered 17 hours ago
user2800user2800
1419
add a comment |
Try this:
=ROUND(((D3+D4+D5-4)/8)-F3-F4,0)
answered 17 hours ago
user2800user2800
1419
Try this:
=ROUND(((D3+D4+D5-4)/8)-F3-F4,0)
answered 17 hours ago
user2800user2800
1419
answered 17 hours ago
user2800user2800
1419
answered 17 hours ago
user2800user2800
1419
answered 17 hours ago
user2800user2800
1419
1419
add a comment |
add a comment |
I don't do Excel so idk their syntax, but brackets are your friend..
(((D3+D4+D5)-4)/8)-F3-F4 would remove ambiguity, even though it's slight overkill.
Maths operators will tend to do multiplication & division first; humans tend to do it in the order they read it [unless they're mathematicians;)
answered 21 hours ago
TetsujinTetsujin
15.9k53462
add a comment |
I don't do Excel so idk their syntax, but brackets are your friend..
(((D3+D4+D5)-4)/8)-F3-F4 would remove ambiguity, even though it's slight overkill.
Maths operators will tend to do multiplication & division first; humans tend to do it in the order they read it [unless they're mathematicians;)
answered 21 hours ago
TetsujinTetsujin
15.9k53462
add a comment |
I don't do Excel so idk their syntax, but brackets are your friend..
(((D3+D4+D5)-4)/8)-F3-F4 would remove ambiguity, even though it's slight overkill.
Maths operators will tend to do multiplication & division first; humans tend to do it in the order they read it [unless they're mathematicians;)
answered 21 hours ago
TetsujinTetsujin
15.9k53462
I don't do Excel so idk their syntax, but brackets are your friend..
(((D3+D4+D5)-4)/8)-F3-F4 would remove ambiguity, even though it's slight overkill.
Maths operators will tend to do multiplication & division first; humans tend to do it in the order they read it [unless they're mathematicians;)
answered 21 hours ago
TetsujinTetsujin
15.9k53462
answered 21 hours ago
TetsujinTetsujin
15.9k53462
answered 21 hours ago
TetsujinTetsujin
15.9k53462
answered 21 hours ago
TetsujinTetsujin
15.9k53462
15.9k53462
add a comment |
add a comment |
Gail Sabourin is a new contributor. Be nice, and check out our Code of Conduct.
Gail Sabourin is a new contributor. Be nice, and check out our Code of Conduct.
Gail Sabourin is a new contributor. Be nice, and check out our Code of Conduct.
Gail Sabourin 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%2f1421748%2fplease-fix-my-formula-for-microsoft-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
4
Better you share sample data along with expected result, will help us to test data and fit it !!
– Rajesh S
22 hours ago