{"id":407,"date":"2020-10-23T02:06:47","date_gmt":"2020-10-23T06:06:47","guid":{"rendered":"http:\/\/blog.fitnyc.edu\/professorshloming\/?p=407"},"modified":"2020-10-23T02:06:47","modified_gmt":"2020-10-23T06:06:47","slug":"can-you-help-me-go-from-a-decimal-to-a-rounded-percent-on-google-spreadsheets","status":"publish","type":"post","link":"https:\/\/blog.fitnyc.edu\/professorshloming\/2020\/10\/23\/can-you-help-me-go-from-a-decimal-to-a-rounded-percent-on-google-spreadsheets\/","title":{"rendered":"Can you help me go from a decimal to a rounded percent on Google Spreadsheets?"},"content":{"rendered":"<p>Can you help me go from a decimal to a rounded percent on Google Spreadsheets?<\/p>\n<p>ANSWER: Of course!<\/p>\n<ul>\n<li>You can look in the toolbar of the spreadsheet and select the % icon! This will change the decimal into a percent for you. Then you will use the .0 &lt;- icon to round until there are no decimals.<\/li>\n<\/ul>\n<figure id=\"attachment_408\" aria-describedby=\"caption-attachment-408\" style=\"width: 154px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.58.54-AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-408\" src=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.58.54-AM.png\" alt=\"icons for percent and rounding\" width=\"154\" height=\"132\" \/><\/a><figcaption id=\"caption-attachment-408\" class=\"wp-caption-text\">icons for percent and rounding<\/figcaption><\/figure>\n<ul>\n<li>You can use the ROUND function! =ROUND(cell,2)*100 will do the trick. Make sure to add the percent sign in a new cell so the final answer is 23%. Or if your column is labeled Percentage then it is understood that 23 is 23%.<\/li>\n<\/ul>\n<figure id=\"attachment_409\" aria-describedby=\"caption-attachment-409\" style=\"width: 640px\" class=\"wp-caption aligncenter\"><a href=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.57.36-AM.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-large wp-image-409\" src=\"http:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.57.36-AM-1024x229.png\" alt=\"ROUND function\" width=\"640\" height=\"143\" srcset=\"https:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.57.36-AM-1024x229.png 1024w, https:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.57.36-AM-300x67.png 300w, https:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.57.36-AM-768x172.png 768w, https:\/\/blog.fitnyc.edu\/professorshloming\/files\/2020\/10\/Screen-Shot-2020-10-23-at-1.57.36-AM.png 1410w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/a><figcaption id=\"caption-attachment-409\" class=\"wp-caption-text\">ROUND function in Google Spreadsheet to go from a decimal to a rounded percentage<\/figcaption><\/figure>\n<ul>\n<li>Use your mathematical knowledge to round without help. To convert to a percentage you move the decimal point over two places to the right. That means you multiplied by 100. Next\u00a0 you look to see what the number that is NOW in the tenths place (first decimal) is &#8211; if it is 5 or higher then you will round the percent up. If the value of that first decimal place is now less than 5 you will leave the percent as is.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Can you help me go from a decimal to a rounded percent on Google Spreadsheets? ANSWER: Of course! You can look in the toolbar of the spreadsheet and select the % icon! This will change the decimal into a percent for you. Then you will [&hellip;]<\/p>\n","protected":false},"author":386,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[26127,28563,28562],"tags":[],"class_list":["post-407","post","type-post","status-publish","format-standard","hentry","category-assignments","category-googledocs-help","category-ma222"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p3ANrd-6z","_links":{"self":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/posts\/407","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/users\/386"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/comments?post=407"}],"version-history":[{"count":0,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/posts\/407\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/media?parent=407"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/categories?post=407"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.fitnyc.edu\/professorshloming\/wp-json\/wp\/v2\/tags?post=407"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}