{"id":10191,"date":"2022-06-27T14:50:29","date_gmt":"2022-06-27T14:50:29","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=10191"},"modified":"2024-03-26T12:56:35","modified_gmt":"2024-03-26T12:56:35","slug":"diameter-formula","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/","title":{"rendered":"Diameter Formula in Excel"},"content":{"rendered":"\n<p>The diameter of a circle or a sphere is the length of the straight line connecting the center of the circle or sphere with two points on its perimeter or surface.<\/p>\n\n\n\n<p>We can construct formulas in Excel to calculate the diameter if any of the following is known: radius of the circle or sphere, circumference of the circle, area of the circle, or volume of the sphere.<\/p>\n\n\n\n<p>In this tutorial, we will learn how to create Excel formulas we can create to calculate the diameter given different situations.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">The Radius of a Circle or Sphere Is Known<\/h2>\n\n\n\n<p><strong>Radius<\/strong> is the length of the line segment between the center and circumference of a circle or sphere. The <strong>diameter<\/strong> is twice the length of the radius.<\/p>\n\n\n\n<p>We use the following dataset with radiuses in column A to compute the diameter values in column B:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"163\" height=\"134\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png\" alt=\"\" class=\"wp-image-10192\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Use the PRODUCT function<\/h3>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Select cell B2 and enter the formula =PRODUCT(A2,2) as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"210\" height=\"131\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/product-function.png\" alt=\"\" class=\"wp-image-10193\"\/><\/figure>\n\n\n\n<ol type=\"1\" start=\"2\">\n<li>Press Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"194\" height=\"164\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/diameter-calculated.png\" alt=\"\" class=\"wp-image-10194\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=PRODUCT(A2,2)<\/code><\/pre>\n\n\n\n<p>The <strong>PRODUCT<\/strong> function multiplies all the numbers given as arguments. In this case, the function multiplied the radius values in column A with value 2 and returned diameter values in column B.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Use User Defined Function (UDF)<\/h3>\n\n\n\n<p>Let&#8217;s create a <strong>User Defined Function<\/strong> in Excel VBA and use it to calculate the diameter.<\/p>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>In the active worksheet, press <strong>Alt + F11<\/strong> to open the <strong>Visual Basic Editor<\/strong>.<\/li>\n\n\n\n<li>In the <strong>Project Window<\/strong> right-click the workbook and <strong>ins<\/strong><strong>ert a new module<\/strong>:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"466\" height=\"446\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/insert-module-2.png\" alt=\"\" class=\"wp-image-10195\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/insert-module-2.png 466w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/insert-module-2-300x287.png 300w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/figure>\n\n\n\n<ol start=\"3\">\n<li>In the new module type in the following code:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Function RADIUStoDIAMETER(RADIUS As Long) As Long\n    RADIUStoDIAMETER = WorksheetFunction.Product(RADIUS * 2)\nEnd Function\n<\/code><\/pre>\n\n\n\n<ol start=\"4\">\n<li>Save the function procedure.<\/li>\n\n\n\n<li>Save the workbook as a <strong>macro-enabled workbook<\/strong>.<\/li>\n\n\n\n<li>Press <strong>Alt + F11<\/strong> to switch back to the active worksheet.<\/li>\n\n\n\n<li>Select cell B2 and type in the formula =RADIUStoDIAMETER(A2) as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"137\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/enter-udf.png\" alt=\"\" class=\"wp-image-10196\"\/><\/figure>\n\n\n\n<p>We may have noticed that immediately we begin typing in the formula, our UDF appears in the list of the other Excel functions:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"289\" height=\"287\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/radius-to-diameter-function.png\" alt=\"\" class=\"wp-image-10197\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/radius-to-diameter-function.png 289w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/radius-to-diameter-function-150x150.png 150w\" sizes=\"(max-width: 289px) 100vw, 289px\" \/><\/figure>\n\n\n\n<p>We can double-click it or press the tab key to enter it instead of typing it in. This saves time.<\/p>\n\n\n\n<ol start=\"8\">\n<li>Press the Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"187\" height=\"167\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/udf-diameter.png\" alt=\"\" class=\"wp-image-10198\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the User-Defined Function<\/strong><\/p>\n\n\n\n<ul>\n<li>Function RADIUStoDIAMETER(RADIUS As Long) As Long. The function is named and its data type is Long. It takes one argument of the Long data type.<\/li>\n\n\n\n<li>RADIUStoDIAMETER = WorksheetFunction.Product(RADIUS * 2). The worksheet&#8217;s in-built <strong>PRODUCT <\/strong>function multiplies the argument, that is passed to it, by <strong>2<\/strong> and assigns the product to the <strong>RADIUStoDIAMETER variable<\/strong>. The <strong>RADIUStoDIAMETER function<\/strong> then returns this product as the diameter value.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Circumference of Circle or Sphere Is Known<\/h2>\n\n\n\n<p>The circumference is the length of the closed curve of a circle or sphere. It is equal to <strong>pi (3.1416) times the diameter<\/strong>. This means that we can get the diameter by dividing the circumference by pi.<\/p>\n\n\n\n<p>We use the following dataset with circumference values in column A to compute the diameter values in column B:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"139\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/circumference-diameter.png\" alt=\"\" class=\"wp-image-10199\"\/><\/figure>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Select cell B2.<\/li>\n\n\n\n<li>Type in the formula =A2\/PI() as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"200\" height=\"136\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/cir-dia-formula.png\" alt=\"\" class=\"wp-image-10200\"\/><\/figure>\n\n\n\n<ol start=\"3\">\n<li>Press the Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"217\" height=\"147\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/decimal-diameters.png\" alt=\"\" class=\"wp-image-10201\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A2\/PI()<\/code><\/pre>\n\n\n\n<p>The value in cell A2 is divided by the value returned by the Excel in-built pi function.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Use a User Defined Function (UDF)<\/h3>\n\n\n\n<p>We can create a UDF using Excel VBA and use it to calculate diameter values given circumference values.<\/p>\n\n\n\n<p>We follow the steps below:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Open the VBE and Insert a new module.<\/li>\n\n\n\n<li>Type in the following function procedure:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Function CIRtoDIA(CIR As Long) As Long\n    CIRtoDIA = CIR \/ WorksheetFunction.Pi\nEnd Function<\/code><\/pre>\n\n\n\n<ol type=\"1\" start=\"3\">\n<li>Select cell B2 and key in the formula =CIRtoDIA(A2) as below:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"230\" height=\"132\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/cir-to-dia-udf.png\" alt=\"\" class=\"wp-image-10202\"\/><\/figure>\n\n\n\n<ol start=\"4\">\n<li>Press Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"230\" height=\"168\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/cir-to-dia-udf-results.png\" alt=\"\" class=\"wp-image-10203\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the CIRtoDIA User-Defined Function<\/strong><\/p>\n\n\n\n<ul>\n<li>Function CIRtoDIA(CIR As Long) As Long. The function is named <strong>CIRtoDIA<\/strong> (Circumference to Diameter). Its data type is Long. It takes one argument (CIR) of the Long data type.<\/li>\n\n\n\n<li>CIRtoDIA = CIR \/ WorksheetFunction.Pi. The value passed to the function during execution is stored in the CIR variable. It is then divided by the pi value which is returned by the in-built pi worksheet function. The result is assigned to the CIRtoDIA variable and it is the value returned by the CIRtoDIA function as the diameter value.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">The area of the Circle Is Known<\/h2>\n\n\n\n<p>We use the following dataset with area values in column A to compute the diameter values in column B:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"175\" height=\"139\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/area-dataset.png\" alt=\"\" class=\"wp-image-10204\"\/><\/figure>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Select cell B2.<\/li>\n\n\n\n<li>Type in the formula =SQRT((A2*4)\/PI()) as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"222\" height=\"133\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/squareroot-formula.png\" alt=\"\" class=\"wp-image-10205\"\/><\/figure>\n\n\n\n<ol start=\"3\">\n<li>Press Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"186\" height=\"161\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/squareroot-results.png\" alt=\"\" class=\"wp-image-10206\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=SQRT((A2*4)\/PI())<\/code><\/pre>\n\n\n\n<p>The <a href=\"https:\/\/officetuts.net\/excel\/formulas\/find-the-area-of-a-circle\/\">area of a circle<\/a> is the product of the square of the diameter and Pi divided by 4. <strong>Area = D<sup>2<\/sup>.\u03c0\/4<\/strong>.<\/p>\n\n\n\n<p>This means that the diameter is equal to the square root of four times the area divided by <strong>Pi<\/strong>.<\/p>\n\n\n\n<p>In the formula, the area in cell A2 is multiplied by 4. The product is divided by the value returned by the <strong>Pi<\/strong> function. The resultant value is passed to the <strong>SQRT function<\/strong> which returns the square root as the diameter value.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Use a User-Defined Function<\/h3>\n\n\n\n<p>We create a UDF to use by using the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Open the VBEand insert a new module.<\/li>\n\n\n\n<li>In the new module, type in the following function procedure:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Function AREAtoDIA(AREA As Long) As Long\n    AREAtoDIA = Sqr((AREA * 4) \/ WorksheetFunction.Pi)\nEnd Function\n<\/code><\/pre>\n\n\n\n<ol start=\"3\">\n<li>Select cell B2 and type in the formula =AREAtoDIA(A2) as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"212\" height=\"136\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/area-to-dia-formula.png\" alt=\"\" class=\"wp-image-10207\"\/><\/figure>\n\n\n\n<ol start=\"4\">\n<li>Press the Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"204\" height=\"173\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/area-diameter-results.png\" alt=\"\" class=\"wp-image-10208\"\/><\/figure>\n\n\n\n<p><strong><strong>Explanation of the AREAtoDIA User-Defined Function<\/strong><\/strong><\/p>\n\n\n\n<ul>\n<li>Function AREAtoDIA(AREA As Long) As Long. The function is named <strong>AREAtoDIA<\/strong> (Area to Diameter). Its data type is Long. It takes one argument (AREA) of the Long data type.<\/li>\n\n\n\n<li>AREAtoDIA = Sqr((AREA * 4) \/ WorksheetFunction.Pi). The value passed to the function during execution is stored in the <strong>AREA <\/strong>variable<strong>. <\/strong>It is then multiplied by 4. The result is then divided by the value returned by the in-built Pi worksheet function. The result is passed to the in-built Sqr VBA function. The <strong>Sqr function<\/strong> returns the square root of the value which is the diameter of the circle or sphere.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">The Volume of the Sphere Is Known<\/h2>\n\n\n\n<p>We use the following dataset with volume values in column A to compute the diameter values in column B:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"224\" height=\"144\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/volume-diameter.png\" alt=\"\" class=\"wp-image-10209\"\/><\/figure>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Select cell B2 and type in the formula =((A2*6)\/PI())^(1\/3) as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"298\" height=\"137\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/volume-diameter-formula.png\" alt=\"\" class=\"wp-image-10210\"\/><\/figure>\n\n\n\n<ol start=\"2\">\n<li>Press the Enter key and double-click or drag down the fill handle to copy the formula down the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"250\" height=\"177\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/volume-diameter-results.png\" alt=\"\" class=\"wp-image-10211\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the formula<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=((A2*6)\/PI())^(1\/3)<\/code><\/pre>\n\n\n\n<p>The diameter of a sphere is equal to the cube root of the volume multiplied by six and the product divided by Pi.<\/p>\n\n\n\n<p>The formula implements this logic by:<\/p>\n\n\n\n<ul>\n<li>(A2*6). The volume in Cell A2 is multiplied by 6.<\/li>\n\n\n\n<li>(A2*6)\/PI(). The product from the previous step is divided by the Pi value returned by the Pi function.<\/li>\n\n\n\n<li>((A2*6)\/PI())^(1\/3). The cube root of the result from the previous step is calculated. This is the diameter of the sphere.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Use a User-Defined Function<\/h3>\n\n\n\n<p>We can create a UDF so that the diameter of the sphere is calculated in a single step.<\/p>\n\n\n\n<p>We use the following steps:<\/p>\n\n\n\n<ol type=\"1\">\n<li>Open the VBE and insert a new module.<\/li>\n\n\n\n<li>In the new module type in the following code:<\/li>\n<\/ol>\n\n\n\n<pre class=\"wp-block-code\"><code>Function VOLtoDIA(VOL As Long) As Long\n    VOLtoDIA = ((VOL * 6) \/ WorksheetFunction.Pi) ^ (1 \/ 3)\nEnd Function<\/code><\/pre>\n\n\n\n<ol type=\"1\" start=\"3\">\n<li>Select cell B2 and type in the formula =VOLtoDIA(A2) as follows:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"252\" height=\"140\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/vol-to-dia-udf.png\" alt=\"\" class=\"wp-image-10212\"\/><\/figure>\n\n\n\n<ol start=\"4\">\n<li>Press the Enter key and double-click or&nbsp; drag down the fill handle to <a href=\"https:\/\/officetuts.net\/excel\/vba\/copy-formula-down-in-vba\/\">copy the formula down<\/a> the column:<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"248\" height=\"167\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/vol-to-dia-results.png\" alt=\"\" class=\"wp-image-10213\"\/><\/figure>\n\n\n\n<p><strong>Explanation of the VOLtoDIA User-Defined Function<\/strong><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>Function VOLtoDIA(VOL As Long) As Long\n    VOLtoDIA = ((VOL * 6) \/ WorksheetFunction.Pi) ^ (1 \/ 3)\nEnd Function<\/code><\/pre>\n\n\n\n<ul>\n<li>Function VOLtoDIA(VOL As Long) As Long. The function is named <strong>VOLtoDIA<\/strong> (Volume to Diameter). Its data type is Long. It takes one argument (VOL) of the Long data type.<\/li>\n\n\n\n<li>VOLtoDIA = ((VOL * 6) \/ WorksheetFunction.Pi) ^ (1 \/ 3). The value passed to the function during execution is stored in the <strong>VOL <\/strong>variable<strong>. <\/strong>It is then multiplied by 6. The product is then divided by the value returned by the in-built Pi worksheet function. The cube root of the result of this division is calculated and assigned to the VOLtoDIA variable.<\/li>\n\n\n\n<li>The function returns the value in the VOLtoDIA variable as the diameter of the sphere.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In this tutorial we have looked at several approaches we can use to come up with formulas to calculate the <a href=\"https:\/\/officetuts.net\/excel\/examples\/typing-diameter-symbol-in-excel-or-word\/\">diameter of circles and spheres in Excel<\/a>.<\/p>\n\n\n\n<p>These formulas can be applied in different situations: when the radius of the sphere or circle is known, when the area of the circle is known, when the circumference of the circle or sphere is known, or when the volume of the sphere is known.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The diameter of a circle or a sphere is the length of the straight line connecting the center of the circle or sphere&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[21],"tags":[190],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Diameter Formula in Excel<\/title>\n<meta name=\"description\" content=\"Learn how to calculate the diameter of a circle or sphere in Excel by constructing formulas based on the radius, circumference, area, or volume.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Diameter Formula in Excel\" \/>\n<meta property=\"og:description\" content=\"Learn how to calculate the diameter of a circle or sphere in Excel by constructing formulas based on the radius, circumference, area, or volume.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-27T14:50:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-26T12:56:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png\" \/>\n<meta name=\"author\" content=\"Christopher Sirali\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christopher Sirali\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\"},\"author\":{\"name\":\"Christopher Sirali\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\"},\"headline\":\"Diameter Formula in Excel\",\"datePublished\":\"2022-06-27T14:50:29+00:00\",\"dateModified\":\"2024-03-26T12:56:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\"},\"wordCount\":1440,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png\",\"keywords\":[\"pinterest\"],\"articleSection\":[\"examples\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\",\"url\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\",\"name\":\"Diameter Formula in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png\",\"datePublished\":\"2022-06-27T14:50:29+00:00\",\"dateModified\":\"2024-03-26T12:56:35+00:00\",\"description\":\"Learn how to calculate the diameter of a circle or sphere in Excel by constructing formulas based on the radius, circumference, area, or volume.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png\",\"width\":163,\"height\":134},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Diameter Formula in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370\",\"name\":\"Christopher Sirali\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g\",\"caption\":\"Christopher Sirali\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Diameter Formula in Excel","description":"Learn how to calculate the diameter of a circle or sphere in Excel by constructing formulas based on the radius, circumference, area, or volume.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/","og_locale":"en_US","og_type":"article","og_title":"Diameter Formula in Excel","og_description":"Learn how to calculate the diameter of a circle or sphere in Excel by constructing formulas based on the radius, circumference, area, or volume.","og_url":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/","article_published_time":"2022-06-27T14:50:29+00:00","article_modified_time":"2024-03-26T12:56:35+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png"}],"author":"Christopher Sirali","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Christopher Sirali","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/"},"author":{"name":"Christopher Sirali","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370"},"headline":"Diameter Formula in Excel","datePublished":"2022-06-27T14:50:29+00:00","dateModified":"2024-03-26T12:56:35+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/"},"wordCount":1440,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png","keywords":["pinterest"],"articleSection":["examples"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/","url":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/","name":"Diameter Formula in Excel","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png","datePublished":"2022-06-27T14:50:29+00:00","dateModified":"2024-03-26T12:56:35+00:00","description":"Learn how to calculate the diameter of a circle or sphere in Excel by constructing formulas based on the radius, circumference, area, or volume.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2022\/06\/dataset-radius-diameter.png","width":163,"height":134},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/examples\/diameter-formula\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Diameter Formula in Excel"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/b303a8b219a448ca09f1e9eed3903370","name":"Christopher Sirali","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/21aaff468311813001dc2723f1937cf0?s=96&d=mm&r=g","caption":"Christopher Sirali"}}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10191"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=10191"}],"version-history":[{"count":10,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10191\/revisions"}],"predecessor-version":[{"id":17288,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/10191\/revisions\/17288"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=10191"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=10191"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=10191"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}