Imported values in Google Sheets from Google Forms
Using Google Forms for a quiz...
The quiz is graded /30.
Value is transmitted into Google Sheets.
Cell C2 displays a value of grade... here, 14/30 (as an example)
Value for cell C2 reads as 14
Attempting to get the value of D2 to show a mark on 100...=C2/30 (this should give me 46.6%) but it returns a value of 0
Why won't it pick up the value of C2 as the value 14 it shows in the fx-box?
How can I get it to pick up the value from the cell to then perform more functions?
google-sheets formulas
edited Feb 13 at 12:13
user0
9,99171533
migrated from superuser.com Feb 12 at 7:19
This question came from our site for computer enthusiasts and power users.
add a comment |
Using Google Forms for a quiz...
The quiz is graded /30.
Value is transmitted into Google Sheets.
Cell C2 displays a value of grade... here, 14/30 (as an example)
Value for cell C2 reads as 14
Attempting to get the value of D2 to show a mark on 100...=C2/30 (this should give me 46.6%) but it returns a value of 0
Why won't it pick up the value of C2 as the value 14 it shows in the fx-box?
How can I get it to pick up the value from the cell to then perform more functions?
google-sheets formulas
edited Feb 13 at 12:13
user0
9,99171533
migrated from superuser.com Feb 12 at 7:19
This question came from our site for computer enthusiasts and power users.
add a comment |
Using Google Forms for a quiz...
The quiz is graded /30.
Value is transmitted into Google Sheets.
Cell C2 displays a value of grade... here, 14/30 (as an example)
Value for cell C2 reads as 14
Attempting to get the value of D2 to show a mark on 100...=C2/30 (this should give me 46.6%) but it returns a value of 0
Why won't it pick up the value of C2 as the value 14 it shows in the fx-box?
How can I get it to pick up the value from the cell to then perform more functions?
google-sheets formulas
edited Feb 13 at 12:13
user0
9,99171533
Using Google Forms for a quiz...
The quiz is graded /30.
Value is transmitted into Google Sheets.
Cell C2 displays a value of grade... here, 14/30 (as an example)
Value for cell C2 reads as 14
Attempting to get the value of D2 to show a mark on 100...=C2/30 (this should give me 46.6%) but it returns a value of 0
Why won't it pick up the value of C2 as the value 14 it shows in the fx-box?
How can I get it to pick up the value from the cell to then perform more functions?
google-sheets formulas
google-sheets formulas
edited Feb 13 at 12:13
user0
9,99171533
edited Feb 13 at 12:13
user0
9,99171533
edited Feb 13 at 12:13
user0
9,99171533
edited Feb 13 at 12:13
user0
9,99171533
edited Feb 13 at 12:13
user0
9,99171533
9,99171533
asked Feb 11 at 5:10
Luz Arroyave
migrated from superuser.com Feb 12 at 7:19
This question came from our site for computer enthusiasts and power users.
migrated from superuser.com Feb 12 at 7:19
This question came from our site for computer enthusiasts and power users.
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
If the cell values are entered as numbers, then you will be able to perform the functions you are requesting. I would first double-check to ensure that the values that are within the spreadsheet are formatted as numbers.
I have had some difficulty with performing basic functions like the one you have presented only to find out that the spreadsheet is not treating the values in the cell as the appropriate type of data.
Next, I would then check the number of decimals the function is being rounded to. If the rounding is to the 0th decimal place, then you will not see a result for the function =14/30. That function would result in the answer of 0.466667, which would be rounded to 0.
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
add a comment |
=ROUND(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 2)&"%"=ROUND(A2/B2*100, 2)&"%"=TEXT(A2/B2, "#.#0%")=TEXT(A2/B2, "#.#%")=TEXT(ROUNDDOWN(A2/B2, 3), "#.#%")
answered Feb 13 at 12:08
user0user0
9,99171533
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "34"
};
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: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
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
},
noCode: 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%2fwebapps.stackexchange.com%2fquestions%2f125231%2fimported-values-in-google-sheets-from-google-forms%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
If the cell values are entered as numbers, then you will be able to perform the functions you are requesting. I would first double-check to ensure that the values that are within the spreadsheet are formatted as numbers.
I have had some difficulty with performing basic functions like the one you have presented only to find out that the spreadsheet is not treating the values in the cell as the appropriate type of data.
Next, I would then check the number of decimals the function is being rounded to. If the rounding is to the 0th decimal place, then you will not see a result for the function =14/30. That function would result in the answer of 0.466667, which would be rounded to 0.
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
add a comment |
If the cell values are entered as numbers, then you will be able to perform the functions you are requesting. I would first double-check to ensure that the values that are within the spreadsheet are formatted as numbers.
I have had some difficulty with performing basic functions like the one you have presented only to find out that the spreadsheet is not treating the values in the cell as the appropriate type of data.
Next, I would then check the number of decimals the function is being rounded to. If the rounding is to the 0th decimal place, then you will not see a result for the function =14/30. That function would result in the answer of 0.466667, which would be rounded to 0.
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
add a comment |
If the cell values are entered as numbers, then you will be able to perform the functions you are requesting. I would first double-check to ensure that the values that are within the spreadsheet are formatted as numbers.
I have had some difficulty with performing basic functions like the one you have presented only to find out that the spreadsheet is not treating the values in the cell as the appropriate type of data.
Next, I would then check the number of decimals the function is being rounded to. If the rounding is to the 0th decimal place, then you will not see a result for the function =14/30. That function would result in the answer of 0.466667, which would be rounded to 0.
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
If the cell values are entered as numbers, then you will be able to perform the functions you are requesting. I would first double-check to ensure that the values that are within the spreadsheet are formatted as numbers.
I have had some difficulty with performing basic functions like the one you have presented only to find out that the spreadsheet is not treating the values in the cell as the appropriate type of data.
Next, I would then check the number of decimals the function is being rounded to. If the rounding is to the 0th decimal place, then you will not see a result for the function =14/30. That function would result in the answer of 0.466667, which would be rounded to 0.
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
answered Feb 12 at 23:01
Government RelationsGovernment Relations
165
165
add a comment |
add a comment |
=ROUND(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 2)&"%"=ROUND(A2/B2*100, 2)&"%"=TEXT(A2/B2, "#.#0%")=TEXT(A2/B2, "#.#%")=TEXT(ROUNDDOWN(A2/B2, 3), "#.#%")
answered Feb 13 at 12:08
user0user0
9,99171533
add a comment |
=ROUND(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 2)&"%"=ROUND(A2/B2*100, 2)&"%"=TEXT(A2/B2, "#.#0%")=TEXT(A2/B2, "#.#%")=TEXT(ROUNDDOWN(A2/B2, 3), "#.#%")
answered Feb 13 at 12:08
user0user0
9,99171533
add a comment |
=ROUND(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 2)&"%"=ROUND(A2/B2*100, 2)&"%"=TEXT(A2/B2, "#.#0%")=TEXT(A2/B2, "#.#%")=TEXT(ROUNDDOWN(A2/B2, 3), "#.#%")
answered Feb 13 at 12:08
user0user0
9,99171533
=ROUND(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 1)&"%"=ROUNDDOWN(A2/B2*100, 2)&"%"=ROUND(A2/B2*100, 2)&"%"=TEXT(A2/B2, "#.#0%")=TEXT(A2/B2, "#.#%")=TEXT(ROUNDDOWN(A2/B2, 3), "#.#%")
answered Feb 13 at 12:08
user0user0
9,99171533
answered Feb 13 at 12:08
user0user0
9,99171533
answered Feb 13 at 12:08
user0user0
9,99171533
answered Feb 13 at 12:08
user0user0
9,99171533
9,99171533
add a comment |
add a comment |
Thanks for contributing an answer to Web Applications Stack Exchange!
- 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%2fwebapps.stackexchange.com%2fquestions%2f125231%2fimported-values-in-google-sheets-from-google-forms%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
