{"id":2268,"date":"2026-10-01T10:48:53","date_gmt":"2026-10-01T10:48:53","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2268"},"modified":"2026-10-31T12:13:21","modified_gmt":"2026-10-31T12:13:21","slug":"writing-functions","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/functions\/writing-functions\/","title":{"rendered":"Writing functions"},"content":{"rendered":"<div class=\"page-content container\">\n<div class=\"fusion-fullwidth fullwidth-box hundred-percent-fullwidth non-hundred-percent-height-scrolling\"  style='background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;'>\n<div class=\"fusion-builder-row fusion-row \">\n<div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_1 fusion-builder-column-169 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height 1_1\"  style='margin-top:0px;margin-bottom:0px;'>\n<div class=\"fusion-column-wrapper\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n\t\t\t\t\t\t[addtoany]<\/p>\n<h1>Writing functions<\/h1>\n<p>There are two ways to write functions. The ways are similar. One way is simply to type the function with the keyboard. The other way is to use the Insert Function tool, which helps beginners along.<\/p>\n<h2>Writing functions with the keyboard<\/h2>\n<p>You write functions with the keyboard as follows:<\/p>\n<ol>\n<li>Type an equals sign &#8221;<code>=<\/code>&#8221; in the formula bar and then the function name followed by an opening parenthesis <code>\"(\"<\/code>.<br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Grundkurs-75.png\" alt=\"Basic course (75)\" width=\"91\" height=\"98\" \/>\n<ul>\n<li>Start typing. As you type, you will see all functions that begin with those letters.<\/li>\n<li>You can use Tab to autocomplete the function name selected in the drop-down list.<\/li>\n<\/ul>\n<\/li>\n<li>Finish typing the function.\n<ul>\n<li>All functions have the form <code>NAME(value,value,...)<\/code><br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Grundkurs-76.png\" alt=\"Basic course (76)\" width=\"177\" height=\"36\" \/><\/li>\n<li>Functions ask for 0 or more arguments:\n<ul>\n<li><code>... \u00a0\u00a0<\/code> means that the preceding argument can be entered any number of times<\/li>\n<li><code>[inv\u00e4rde] \u00a0\u00a0<\/code> means that the argument does not have to be specified<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li>Press Enter.<\/li>\n<\/ol>\n<h2>Writing functions with Insert Function<\/h2>\n<p>Writing functions with Insert Function is easier for beginners but tends to take longer. Do as follows:<\/p>\n<ol>\n<li>Click Insert Function <br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/fx.jpg\" alt=\"fx\" width=\"17\" height=\"17\" \/>.<\/li>\n<li>Choose a function. (Search for a function, choose a function in one of the categories, or choose a function from the most recently used.)<img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Infoga-dialogruta1.jpg\" alt=\"Insert dialog box\" width=\"413\" height=\"310\" \/><\/li>\n<li>Enter the requested values. (Click the small selector button next to the text fields to select cells with the mouse.)<br \/><img loading=\"lazy\" decoding=\"async\" class=\"alignnone\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Funktionsargument.jpg\" alt=\"Function arguments\" width=\"547\" height=\"282\" \/><\/li>\n<\/ol>\n<div class=\"fusion-clearfix\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/div>\n<div class=\"fusion-fullwidth fullwidth-box nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\"  style='background-color: #fff;background-position: top left;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;border-top-width:0px;border-bottom-width:0px;border-color:#f6f6f6;border-top-style:solid;border-bottom-style:solid;'>\n<div class=\"fusion-builder-row fusion-row \">\n<center><\/p>\n<div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_3 fusion-builder-column-170 fusion-one-third fusion-column-first 1_3\"  style='margin-top:0px;margin-bottom:20px;width:33.33%;width:calc(33.33% - ( ( 4% + 4% ) * 0.3333 ) );margin-right: 4%;'>\n<div class=\"fusion-column-wrapper\" style=\"padding: 0px 0px 0px 0px;background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n<h2>Previous<\/h2>\n<p><a href=\"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/functions\/sum\/\" title=\"Sum\">Sum<\/a><\/p>\n<div class=\"fusion-clearfix\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_3 fusion-builder-column-171 fusion-one-third 1_3\"  style='margin-top:0px;margin-bottom:20px;width:33.33%;width:calc(33.33% - ( ( 4% + 4% ) * 0.3333 ) );margin-right: 4%;'>\n<div class=\"fusion-column-wrapper\" style=\"padding: 0px 0px 0px 0px;background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n<h2>Index<\/h2>\n<p><a href=\"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/\" title=\"Excel Basic Course Online\">Excel Basic Course Online<\/a><\/p>\n<div class=\"fusion-clearfix\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_3 fusion-builder-column-172 fusion-one-third fusion-column-last 1_3\"  style='margin-top:0px;margin-bottom:20px;width:33.33%;width:calc(33.33% - ( ( 4% + 4% ) * 0.3333 ) );'>\n<div class=\"fusion-column-wrapper\" style=\"padding: 0px 0px 0px 0px;background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n<h2>Next<\/h2>\n<p><a href=\"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/functions\/referring-to-ranges-of-cells\/\" title=\"Referring to ranges of cells\">Referring to ranges of cells<\/a><\/p>\n<div class=\"fusion-clearfix\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<p><\/center><\/div>\n<\/div>\n<h2>Some of our customers<\/h2>\n<p>We have both large and small companies as customers.<\/p>\n<div class=\"fusion-fullwidth fullwidth-box nonhundred-percent-fullwidth non-hundred-percent-height-scrolling\"  style='background-color: rgba(255,255,255,0);background-position: center center;background-repeat: no-repeat;padding-top:0px;padding-right:0px;padding-bottom:0px;padding-left:0px;'>\n<div class=\"fusion-builder-row fusion-row \">\n<div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_1 fusion-builder-column-173 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height 1_1\"  style='margin-top:0px;margin-bottom:0px;'>\n<div class=\"fusion-column-wrapper\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n\t\t\t\t\t\t<div class=\"fusion-image-carousel fusion-image-carousel-fixed fusion-image-carousel-1\"><div class=\"awb-carousel awb-swiper awb-swiper-carousel awb-carousel--carousel awb-swiper-dots-position-bottom\" data-layout=\"carousel\" data-autoplay=\"no\" data-autoplayspeed=\"2500\" data-autoplaypause=\"no\" data-loop=\"yes\" data-columns=\"5\" data-columnsmedium=\"1\" data-columnssmall=\"1\" data-itemmargin=\"13\" data-itemwidth=\"180\" data-touchscroll=\"no\" data-freemode=\"no\" data-imagesize=\"fixed\" data-scrollitems=\"0\" data-centeredslides=\"no\" data-rotationangle=\"50\" data-depth=\"100\" data-speed=\"500\" data-shadow=\"no\" data-pagination=\"bullets\"><div class=\"swiper-wrapper awb-image-carousel-wrapper fusion-flex-align-items-center\"><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.continental.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Continental-2.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Continental\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.kalmar.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Kalmar-kommun-2.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Kalmar Municipality\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.lundstams.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Lundstams-2.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Lundstams\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.laroverken.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Fria-Laroverken2.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Fria L\u00e4roverken in Sweden AB\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/newsec.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Newsec-2.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Newsec\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/sweden.emc.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/EMC-2.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"EMC\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.fortum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Fortum1.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Fortum\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.navetti.com\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Navetti1.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Navetti\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.stockholm.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Trafikkontoret-Stockholms-stad1.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Stockholm City Transport Administration\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.viafone.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Viafone1.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Viafone\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/www.visma.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Visma1.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Visma\" \/><\/a><\/div><\/div><\/div><div class=\"swiper-slide\"><div class=\"fusion-carousel-item-wrapper\"><div class=\"fusion-image-wrapper hover-type-none\"><a href=\"https:\/\/hushallningssallskapet.se\/\" target=\"_blank\" rel=\"noopener noreferrer\"><img loading=\"lazy\" decoding=\"async\" width=\"156\" height=\"100\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Hushallningssallskapet1.png\" class=\"attachment-blog-medium size-blog-medium\" alt=\"Hush\u00e5llningss\u00e4llskapet\" \/><\/a><\/div><\/div><\/div><\/div><div class=\"awb-swiper-button awb-swiper-button-prev\"><i class=\"awb-icon-angle-left\" aria-hidden=\"true\"><\/i><\/div><div class=\"awb-swiper-button awb-swiper-button-next\"><i class=\"awb-icon-angle-right\" aria-hidden=\"true\"><\/i><\/div><\/div><\/div><\/p>\n<div class=\"fusion-clearfix\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<div  class=\"fusion-layout-column fusion_builder_column fusion_builder_column_1_1 fusion-builder-column-174 fusion-one-full fusion-column-first fusion-column-last fusion-column-no-min-height 1_1\"  style='margin-top:0px;margin-bottom:0px;'>\n<div class=\"fusion-column-wrapper\" style=\"background-position:left top;background-repeat:no-repeat;-webkit-background-size:cover;-moz-background-size:cover;-o-background-size:cover;background-size:cover;\"   data-bg-url=\"\">\n<style type='text\/css'>.reading-box-container-24 .element-bottomshadow:before,.reading-box-container-24 .element-bottomshadow:after{opacity:0.7;}<\/style>\n<div class=\"fusion-reading-box-container reading-box-container-24\" style=\"margin-top:0px;margin-bottom:84px;\">\n<div class=\"reading-box element-bottomshadow\" style=\"background-color:#f6f6f6;border-width:0px;border-color:#f6f6f6;border-top-width:3px;border-top-color:var(--primary_color);border-style:solid;\"><a class=\"button fusion-button button-default button-round fusion-button-large button-large button-flat fusion-desktop-button fusion-tagline-button continue fusion-desktop-button-margin continue-right\" style=\"-webkit-box-shadow:none;-moz-box-shadow:none;box-shadow:none;\" href=\"https:\/\/www.exceldepartment.com\/en\/contact-us\/#kontakta-oss\" target=\"_self\"><span>Contact us<\/span><\/a><\/p>\n<h2>Excel experts<\/h2>\n<div class=\"reading-box-description fusion-reading-box-additional\">We are among the country&#8217;s leading Excel experts. We help you use Excel in the best possible way and achieve better results faster.<\/div>\n<div class=\"fusion-clearfix\"><\/div>\n<p><a class=\"button fusion-button button-default button-round fusion-button-large button-large button-flat fusion-mobile-button continue-right\" style=\"-webkit-box-shadow:none;-moz-box-shadow:none;box-shadow:none;\" href=\"https:\/\/www.exceldepartment.com\/en\/contact-us\/#kontakta-oss\" target=\"_self\"><span>Contact us<\/span><\/a><\/div>\n<\/div>\n<div class=\"fusion-clearfix\"><\/div>\n<\/p><\/div>\n<\/p><\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>This chapter of Excel Basic Course Online shows how to write functions in Excel. You can write functions with the keyboard or insert them with the mouse.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2189,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-with-title","meta":{"footnotes":""},"class_list":["post-2268","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2268","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/comments?post=2268"}],"version-history":[{"count":0,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2268\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2189"}],"wp:attachment":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/media?parent=2268"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}