Excel round 0.34 to 0.35Can Excel show a formula and its result simultaneously?Excel date & time formula-round up cell valueRound up or down to nearest multiple of .05 in ExcelReference cell's formula rather than the value in Excel?Excel not addingHow to fill right a calculation from cells in two Excel sheetsHow to sum numbers in parenthesis within a cell until a certain condition is met?Need assistance Excel formulaWhy does Excel round the least significant digit when I paste in a large number?Excel 2016 Too Many Arguments Error Message
Can’t attend PhD conferences
Should my manager be aware of private LinkedIn approaches I receive? How to politely have this happen?
Cascading Repair Costs following Blown Head Gasket on a 2004 Subaru Outback
Do equal angles necessarily mean a polygon is regular?
Story-based adventure with functions and relationships
A player is constantly pestering me about rules, what do I do as a DM?
C-152 carb heat on before landing in hot weather?
Why is the Turkish president's surname spelt in Russian as Эрдоган, with г?
How can I repair scratches on a painted French door?
Does squid ink pasta bleed?
First-year PhD giving a talk among well-established researchers in the field
Unusual mail headers, evidence of an attempted attack. Have I been pwned?
Sho, greek letter
Should I include salary information on my CV?
Employer wants to use my work email account after I quit, is this legal under German law? Is this a GDPR waiver?
Is my Rep in Stack-Exchange Form?
Why aren't (poly-)cotton tents more popular?
How to split an equation over two lines?
How risky is real estate?
Importance of the principal bundle in Chern-Simons theory
Changing the opacity of lines on a plot based on their value
Using “sparkling” as a diminutive of “spark” in a poem
How to reply to small talk/random facts in a non-offensive way?
Inverse-quotes-quine
Excel round 0.34 to 0.35
Can Excel show a formula and its result simultaneously?Excel date & time formula-round up cell valueRound up or down to nearest multiple of .05 in ExcelReference cell's formula rather than the value in Excel?Excel not addingHow to fill right a calculation from cells in two Excel sheetsHow to sum numbers in parenthesis within a cell until a certain condition is met?Need assistance Excel formulaWhy does Excel round the least significant digit when I paste in a large number?Excel 2016 Too Many Arguments Error Message
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
Let say A1's value is 0.34
If I use =ROUND(A1,2) formula in excel, this will produce 0.34 too.
I know this is the right one.
What I want to do is to change 0.34 value to 0.35
microsoft-excel wps-spreadsheet
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
add a comment |
Let say A1's value is 0.34
If I use =ROUND(A1,2) formula in excel, this will produce 0.34 too.
I know this is the right one.
What I want to do is to change 0.34 value to 0.35
microsoft-excel wps-spreadsheet
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
add a comment |
Let say A1's value is 0.34
If I use =ROUND(A1,2) formula in excel, this will produce 0.34 too.
I know this is the right one.
What I want to do is to change 0.34 value to 0.35
microsoft-excel wps-spreadsheet
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
Let say A1's value is 0.34
If I use =ROUND(A1,2) formula in excel, this will produce 0.34 too.
I know this is the right one.
What I want to do is to change 0.34 value to 0.35
microsoft-excel wps-spreadsheet
microsoft-excel wps-spreadsheet
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
edited Jun 15 at 8:47
fixer1234
20.6k14 gold badges52 silver badges85 bronze badges
20.6k14 gold badges52 silver badges85 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
asked Jun 15 at 8:07
SabrinaSabrina
5131 gold badge5 silver badges18 bronze badges
5131 gold badge5 silver badges18 bronze badges
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
Microsoft Excel provides three functions for round numbers to the nearest multiple
of 0.5:
- To round a number down to nearest 0.5, use the FLOOR function, for example
=FLOOR(A2, 0.5). - To round a number up to nearest 0.5, use the CEILING function, for example
=CEILING(A2, 0.5). - To round a number up or down to nearest 0.5, use the MROUND function,
for example =MROUND(A2, 0.5). Rounding up or down depends on the remainder from
dividing the number by multiple - if the remainder is equal to or greater than
half the value of multiple, the number is rounded upward, otherwise downward.
source
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
1
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
add a comment |
Use =ROUND(A1*2,1)/2 or =MROUND(A1,.05). This lets you round in .05 increments.
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
Thanks but didn't work. I'm still getting0.34
– Sabrina
Jun 15 at 8:21
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%2f1449025%2fexcel-round-0-34-to-0-35%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
Microsoft Excel provides three functions for round numbers to the nearest multiple
of 0.5:
- To round a number down to nearest 0.5, use the FLOOR function, for example
=FLOOR(A2, 0.5). - To round a number up to nearest 0.5, use the CEILING function, for example
=CEILING(A2, 0.5). - To round a number up or down to nearest 0.5, use the MROUND function,
for example =MROUND(A2, 0.5). Rounding up or down depends on the remainder from
dividing the number by multiple - if the remainder is equal to or greater than
half the value of multiple, the number is rounded upward, otherwise downward.
source
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
1
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
add a comment |
Microsoft Excel provides three functions for round numbers to the nearest multiple
of 0.5:
- To round a number down to nearest 0.5, use the FLOOR function, for example
=FLOOR(A2, 0.5). - To round a number up to nearest 0.5, use the CEILING function, for example
=CEILING(A2, 0.5). - To round a number up or down to nearest 0.5, use the MROUND function,
for example =MROUND(A2, 0.5). Rounding up or down depends on the remainder from
dividing the number by multiple - if the remainder is equal to or greater than
half the value of multiple, the number is rounded upward, otherwise downward.
source
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
1
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
add a comment |
Microsoft Excel provides three functions for round numbers to the nearest multiple
of 0.5:
- To round a number down to nearest 0.5, use the FLOOR function, for example
=FLOOR(A2, 0.5). - To round a number up to nearest 0.5, use the CEILING function, for example
=CEILING(A2, 0.5). - To round a number up or down to nearest 0.5, use the MROUND function,
for example =MROUND(A2, 0.5). Rounding up or down depends on the remainder from
dividing the number by multiple - if the remainder is equal to or greater than
half the value of multiple, the number is rounded upward, otherwise downward.
source
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
Microsoft Excel provides three functions for round numbers to the nearest multiple
of 0.5:
- To round a number down to nearest 0.5, use the FLOOR function, for example
=FLOOR(A2, 0.5). - To round a number up to nearest 0.5, use the CEILING function, for example
=CEILING(A2, 0.5). - To round a number up or down to nearest 0.5, use the MROUND function,
for example =MROUND(A2, 0.5). Rounding up or down depends on the remainder from
dividing the number by multiple - if the remainder is equal to or greater than
half the value of multiple, the number is rounded upward, otherwise downward.
source
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
edited Jun 15 at 11:24
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
answered Jun 15 at 8:48
harrymcharrymc
272k14 gold badges284 silver badges599 bronze badges
272k14 gold badges284 silver badges599 bronze badges
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
1
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
add a comment |
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
1
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
interesting. Seems Mround only works for positive values.
– Forward Ed
Jun 15 at 15:04
1
1
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
If negatives involved, try instead =MROUND($A3, SIGN($A3) * 0.5)
– BowlOfRed
Jun 15 at 16:54
add a comment |
Use =ROUND(A1*2,1)/2 or =MROUND(A1,.05). This lets you round in .05 increments.
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
Thanks but didn't work. I'm still getting0.34
– Sabrina
Jun 15 at 8:21
add a comment |
Use =ROUND(A1*2,1)/2 or =MROUND(A1,.05). This lets you round in .05 increments.
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
Thanks but didn't work. I'm still getting0.34
– Sabrina
Jun 15 at 8:21
add a comment |
Use =ROUND(A1*2,1)/2 or =MROUND(A1,.05). This lets you round in .05 increments.
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
Use =ROUND(A1*2,1)/2 or =MROUND(A1,.05). This lets you round in .05 increments.
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
edited Jun 15 at 8:41
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
answered Jun 15 at 8:15
Duke NukemDuke Nukem
6511 gold badge4 silver badges12 bronze badges
6511 gold badge4 silver badges12 bronze badges
Thanks but didn't work. I'm still getting0.34
– Sabrina
Jun 15 at 8:21
add a comment |
Thanks but didn't work. I'm still getting0.34
– Sabrina
Jun 15 at 8:21
Thanks but didn't work. I'm still getting
0.34– Sabrina
Jun 15 at 8:21
Thanks but didn't work. I'm still getting
0.34– Sabrina
Jun 15 at 8:21
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%2f1449025%2fexcel-round-0-34-to-0-35%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
