{"id":2182,"date":"2026-10-01T10:48:43","date_gmt":"2026-10-01T10:48:43","guid":{"rendered":"https:\/\/www.exceldepartment.com\/?page_id=2182"},"modified":"2026-10-31T12:12:52","modified_gmt":"2026-10-31T12:12:52","slug":"formulas","status":"publish","type":"page","link":"https:\/\/www.exceldepartment.com\/en\/excel-course\/excel-basic-course\/formulas\/","title":{"rendered":"Formulas"},"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-57 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>Formulas<\/h1>\n<p>Formulas in Excel are expressions that calculate a value in a cell. It is thanks to formulas that advanced models can be built in Excel. Thanks to formulas we can break our problems down in Excel and create both clear overviews and advanced Excel models.<\/p>\n<p>A formula in a collection of formulas can contain information both to the left and to the right of the equals sign.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1870\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Grundkurs-64.png\" alt=\"Basic course (64)\" width=\"68\" height=\"29\" \/><\/p>\n<p>A formula in Excel always begins with an equals sign. To the right of the equals sign you write your calculation. What the calculation yields ends up as a value in the cell. The value of the cell thus becomes equal to the result of the formula.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1871\" src=\"https:\/\/www.exceldepartment.com\/wp-content\/uploads\/2026\/10\/Grundkurs-65.png\" alt=\"Basic course (65)\" width=\"62\" height=\"25\" \/><\/p>\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-58 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\/copy-and-cut\/copy-and-cut-with-examples\/\" title=\"Copy and cut with examples\">Copy and cut with examples<\/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-59 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-60 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\/formulas\/cells-contain-several-types-of-information\/\" title=\"Cells contain several types of information\">Cells contain several types of information<\/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 clients<\/h2>\n<p>We have both large and small companies as clients.<\/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-61 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 kommun\" \/><\/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 i Sverige 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=\"Trafikkontoret Stockholms stad\" \/><\/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-62 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-10 .element-bottomshadow:before,.reading-box-container-10 .element-bottomshadow:after{opacity:0.7;}<\/style>\n<div class=\"fusion-reading-box-container reading-box-container-10\" 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 is about formulas in Excel. All formulas begin with an equals sign. Formulas are used for all calculations.<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":2120,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"page-with-title","meta":{"footnotes":""},"class_list":["post-2182","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2182","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=2182"}],"version-history":[{"count":0,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2182\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/pages\/2120"}],"wp:attachment":[{"href":"https:\/\/www.exceldepartment.com\/en\/wp-json\/wp\/v2\/media?parent=2182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}