How to show whole numbers to 1 decimal point Announcing the arrival of Valued Associate #679:...
Can inflation occur in a positive-sum game currency system such as the Stack Exchange reputation system?
If a contract sometimes uses the wrong name, is it still valid?
Can a non-EU citizen traveling with me come with me through the EU passport line?
How do I stop a creek from eroding my steep embankment?
Can Pao de Queijo, and similar foods, be kosher for Passover?
If Jon Snow became King of the Seven Kingdoms what would his regnal number be?
List *all* the tuples!
Storing hydrofluoric acid before the invention of plastics
Do I really need recursive chmod to restrict access to a folder?
Is there a concise way to say "all of the X, one of each"?
Why aren't air breathing engines used as small first stages
How to recreate this effect in Photoshop?
Is a manifold-with-boundary with given interior and non-empty boundary essentially unique?
Does accepting a pardon have any bearing on trying that person for the same crime in a sovereign jurisdiction?
What is the musical term for a note that continously plays through a melody?
Check which numbers satisfy the condition [A*B*C = A! + B! + C!]
How discoverable are IPv6 addresses and AAAA names by potential attackers?
Is there a service that would inform me whenever a new direct route is scheduled from a given airport?
How can I make names more distinctive without making them longer?
How to find all the available tools in macOS terminal?
What is the longest distance a 13th-level monk can jump while attacking on the same turn?
Letter Boxed validator
3 doors, three guards, one stone
Is above average number of years spent on PhD considered a red flag in future academia or industry positions?
How to show whole numbers to 1 decimal point
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)Excel: Calculate average number of days between a range of datesTriggering a formula based on value of a cellGeneral and Text Format covert data to exponentialHow to count the number of cell pairs containing x and y values larger/smaller than the mean in excel?Return sum of multiple vlookupsHow to tell Excel to wait to update a cell (in order to avoid circular reference error)?Assign Nested Sequential unique numbers for items in Excel TableCompare three cells and the output is different pending on the answers in three cellsINDEX, MATCH with IFGet address of offset formula in another cell Excel
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
I'm using the following formula to display results based on the answers obtained from another calculation. '=IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1)))'.
The formula works with no issue, except for when the answer in A1 is less than 10, and the number in B1 is a whole number. I need the whole number to be displayed to 1 decimal place.
Any ideas?
microsoft-excel-2016
asked yesterday
PaulPaul
1
New contributor
Paul 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'm using the following formula to display results based on the answers obtained from another calculation. '=IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1)))'.
The formula works with no issue, except for when the answer in A1 is less than 10, and the number in B1 is a whole number. I need the whole number to be displayed to 1 decimal place.
Any ideas?
microsoft-excel-2016
asked yesterday
PaulPaul
1
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
This Formula? =IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1))) but this formula doesn't make sense!
– Lee
yesterday
It would help if you would show some examples of what results you want from what input.
– Scott
22 hours ago
add a comment |
I'm using the following formula to display results based on the answers obtained from another calculation. '=IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1)))'.
The formula works with no issue, except for when the answer in A1 is less than 10, and the number in B1 is a whole number. I need the whole number to be displayed to 1 decimal place.
Any ideas?
microsoft-excel-2016
asked yesterday
PaulPaul
1
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I'm using the following formula to display results based on the answers obtained from another calculation. '=IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1)))'.
The formula works with no issue, except for when the answer in A1 is less than 10, and the number in B1 is a whole number. I need the whole number to be displayed to 1 decimal place.
Any ideas?
microsoft-excel-2016
microsoft-excel-2016
asked yesterday
PaulPaul
1
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
PaulPaul
1
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
PaulPaul
1
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked yesterday
PaulPaul
1
asked yesterday
PaulPaul
1
1
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Paul is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
This Formula? =IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1))) but this formula doesn't make sense!
– Lee
yesterday
It would help if you would show some examples of what results you want from what input.
– Scott
22 hours ago
add a comment |
This Formula? =IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1))) but this formula doesn't make sense!
– Lee
yesterday
It would help if you would show some examples of what results you want from what input.
– Scott
22 hours ago
This Formula? =IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1))) but this formula doesn't make sense!
– Lee
yesterday
This Formula? =IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1))) but this formula doesn't make sense!
– Lee
yesterday
It would help if you would show some examples of what results you want from what input.
– Scott
22 hours ago
It would help if you would show some examples of what results you want from what input.
– Scott
22 hours ago
add a comment |
1 Answer
1
active
oldest
votes
Do you really need to have a rounded value,
that you can use for other calculations,
or is it good enough to display the desired number of digits?
If the latter
(if it’s good enough to display the desired number of digits),
it may be easier to do this with formatting.
- Format cell
B1(or the cells in ColumnB, if appropriate)
as “Number” with 0 decimal places. - With cell
B1(or the cells in ColumnB) selected,
click on “Conditional Formatting” → “New Rule”. - Select “Use a formula to select which cells to format”.
- In the “Format values where this formula is true” box, enter
=A1<10. - Click on the “Format” button
and specify a format of “Number” with 1 decimal place.
answered 22 hours ago
ScottScott
16.2k113990
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
});
}
});
Paul 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%2f1425456%2fhow-to-show-whole-numbers-to-1-decimal-point%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
Do you really need to have a rounded value,
that you can use for other calculations,
or is it good enough to display the desired number of digits?
If the latter
(if it’s good enough to display the desired number of digits),
it may be easier to do this with formatting.
- Format cell
B1(or the cells in ColumnB, if appropriate)
as “Number” with 0 decimal places. - With cell
B1(or the cells in ColumnB) selected,
click on “Conditional Formatting” → “New Rule”. - Select “Use a formula to select which cells to format”.
- In the “Format values where this formula is true” box, enter
=A1<10. - Click on the “Format” button
and specify a format of “Number” with 1 decimal place.
answered 22 hours ago
ScottScott
16.2k113990
add a comment |
Do you really need to have a rounded value,
that you can use for other calculations,
or is it good enough to display the desired number of digits?
If the latter
(if it’s good enough to display the desired number of digits),
it may be easier to do this with formatting.
- Format cell
B1(or the cells in ColumnB, if appropriate)
as “Number” with 0 decimal places. - With cell
B1(or the cells in ColumnB) selected,
click on “Conditional Formatting” → “New Rule”. - Select “Use a formula to select which cells to format”.
- In the “Format values where this formula is true” box, enter
=A1<10. - Click on the “Format” button
and specify a format of “Number” with 1 decimal place.
answered 22 hours ago
ScottScott
16.2k113990
add a comment |
Do you really need to have a rounded value,
that you can use for other calculations,
or is it good enough to display the desired number of digits?
If the latter
(if it’s good enough to display the desired number of digits),
it may be easier to do this with formatting.
- Format cell
B1(or the cells in ColumnB, if appropriate)
as “Number” with 0 decimal places. - With cell
B1(or the cells in ColumnB) selected,
click on “Conditional Formatting” → “New Rule”. - Select “Use a formula to select which cells to format”.
- In the “Format values where this formula is true” box, enter
=A1<10. - Click on the “Format” button
and specify a format of “Number” with 1 decimal place.
answered 22 hours ago
ScottScott
16.2k113990
Do you really need to have a rounded value,
that you can use for other calculations,
or is it good enough to display the desired number of digits?
If the latter
(if it’s good enough to display the desired number of digits),
it may be easier to do this with formatting.
- Format cell
B1(or the cells in ColumnB, if appropriate)
as “Number” with 0 decimal places. - With cell
B1(or the cells in ColumnB) selected,
click on “Conditional Formatting” → “New Rule”. - Select “Use a formula to select which cells to format”.
- In the “Format values where this formula is true” box, enter
=A1<10. - Click on the “Format” button
and specify a format of “Number” with 1 decimal place.
answered 22 hours ago
ScottScott
16.2k113990
answered 22 hours ago
ScottScott
16.2k113990
answered 22 hours ago
ScottScott
16.2k113990
answered 22 hours ago
ScottScott
16.2k113990
16.2k113990
add a comment |
add a comment |
Paul is a new contributor. Be nice, and check out our Code of Conduct.
Paul is a new contributor. Be nice, and check out our Code of Conduct.
Paul is a new contributor. Be nice, and check out our Code of Conduct.
Paul 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%2f1425456%2fhow-to-show-whole-numbers-to-1-decimal-point%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
This Formula? =IF(A1<=10,MROUND(B1,0.1),IF(A1>10,MROUND(B1,1))) but this formula doesn't make sense!
– Lee
yesterday
It would help if you would show some examples of what results you want from what input.
– Scott
22 hours ago