{"id":11574,"date":"2023-11-17T12:43:59","date_gmt":"2023-11-17T11:43:59","guid":{"rendered":"https:\/\/actonic.de\/?p=11574"},"modified":"2023-11-17T12:51:53","modified_gmt":"2023-11-17T11:51:53","slug":"how-to-use-excel-if-functions-in-confluence","status":"publish","type":"post","link":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/","title":{"rendered":"How to use Excel IF functions in Confluence"},"content":{"rendered":"

[vc_row][vc_column][vc_column_text]<\/p>\n

The Solution: Inline Table Editing<\/h2>\n

Inline Table Editing<\/strong><\/a> is a tool that allows you to sort, filter and use Confluence tables for calculations – easily in view mode! <\/strong>The fact that you don\u2019t have to jump into editing mode first saves you valuable time. You can import Excel tables directly or create tables in Confluence yourself. Switch to view mode and start having fun with over 300 built-in functions<\/strong><\/a> for your calculations.<\/p>\n

How to use Excel IF Functions in View Mode<\/h2>\n
    \n
  1. \n

    Go to Confluence, pick your table<\/p>\n<\/li>\n

  2. \n

    Create a row or column where you want to track your if function<\/p>\n<\/li>\n

  3. \n

    Stay in the view mode and start typing your function<\/p>\n<\/li>\n

  4. \n

    Hit Enter and use our autofill function to assign the formula to the cells below.<\/p>\n<\/li>\n<\/ol>\n

    [\/vc_column_text][vc_single_image image=”11575″ img_size=”full” alignment=”center” onclick=”custom_link”][vc_column_text]<\/p>\n

    5. In our example, we want to display if the column’s value is \u201cEast\u201d. So we type in that function: =IF(D2=”East”, “Yes”, “No”)<\/p>\n

    Mastering IF Functions in Confluence<\/h2>\n

    Inline Table Editing isn’t just about displaying data; it’s about making data-driven decisions in Confluence a breeze. Say goodbye to static tables and embrace the dynamic potential of Excel-like IF functions in Confluence. No coding, no switching to the edit mode. Just do complex calculations easily in view mode.<\/p>\n

    Try Inline Table Editing <\/strong><\/a>now!<\/p>\n

    [\/vc_column_text][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"

    Did you ever want to use Excel IF functions in Confluence? With this solution, Excel fans can handle complex calculations in Confluence tables. Even in view mode!<\/p>\n","protected":false},"author":15,"featured_media":11577,"comment_status":"closed","ping_status":"open","sticky":false,"template":"single_cta.php","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[281,296],"class_list":["post-11574","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized","tag-confluence-en","tag-inline-table-editing-en"],"acf":[],"yoast_head":"\nHow to use Excel IF functions in Confluence - Actonic \u2013 Unfolding your potential<\/title>\n<meta name=\"description\" content=\"Excel If functions in Confluence \u2714\ufe0f Inline Table Editing \u2714\ufe0f Calculations in view mode \u2714\ufe0f read now!\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to use Excel IF functions in Confluence\" \/>\n<meta property=\"og:description\" content=\"Excel If functions in Confluence \u2714\ufe0f Inline Table Editing \u2714\ufe0f Calculations in view mode \u2714\ufe0f read now!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/\" \/>\n<meta property=\"og:site_name\" content=\"Actonic \u2013 Unfolding your potential\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-17T11:43:59+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-17T11:51:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Patricia Modispacher\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Patricia Modispacher\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/\"},\"author\":{\"name\":\"Patricia Modispacher\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\"},\"headline\":\"How to use Excel IF functions in Confluence\",\"datePublished\":\"2023-11-17T11:43:59+00:00\",\"dateModified\":\"2023-11-17T11:51:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/\"},\"wordCount\":251,\"image\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/40-Excel-If-Functions-in-Confluence-EN.jpg\",\"keywords\":[\"Confluence\",\"Inline Table Editing\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/\",\"name\":\"How to use Excel IF functions in Confluence - Actonic \u2013 Unfolding your potential\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/40-Excel-If-Functions-in-Confluence-EN.jpg\",\"datePublished\":\"2023-11-17T11:43:59+00:00\",\"dateModified\":\"2023-11-17T11:51:53+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\"},\"description\":\"Excel If functions in Confluence \u2714\ufe0f Inline Table Editing \u2714\ufe0f Calculations in view mode \u2714\ufe0f read now!\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#primaryimage\",\"url\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/40-Excel-If-Functions-in-Confluence-EN.jpg\",\"contentUrl\":\"https:\\\/\\\/actonic.de\\\/wp-content\\\/uploads\\\/2023\\\/11\\\/40-Excel-If-Functions-in-Confluence-EN.jpg\",\"width\":1200,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/how-to-use-excel-if-functions-in-confluence\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/actonic.de\\\/en\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to use Excel IF functions in Confluence\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/\",\"name\":\"Actonic \u2013 Unfolding your potential\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/actonic.de\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/actonic.de\\\/en\\\/#\\\/schema\\\/person\\\/c700b8aadff4de9c01f096c78149a808\",\"name\":\"Patricia Modispacher\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g\",\"caption\":\"Patricia Modispacher\"},\"url\":\"https:\\\/\\\/actonic.de\\\/en\\\/author\\\/patricia-modispacher\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to use Excel IF functions in Confluence - Actonic \u2013 Unfolding your potential","description":"Excel If functions in Confluence \u2714\ufe0f Inline Table Editing \u2714\ufe0f Calculations in view mode \u2714\ufe0f read now!","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:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/","og_locale":"en_US","og_type":"article","og_title":"How to use Excel IF functions in Confluence","og_description":"Excel If functions in Confluence \u2714\ufe0f Inline Table Editing \u2714\ufe0f Calculations in view mode \u2714\ufe0f read now!","og_url":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/","og_site_name":"Actonic \u2013 Unfolding your potential","article_published_time":"2023-11-17T11:43:59+00:00","article_modified_time":"2023-11-17T11:51:53+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg","type":"image\/jpeg"}],"author":"Patricia Modispacher","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Patricia Modispacher","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#article","isPartOf":{"@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/"},"author":{"name":"Patricia Modispacher","@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808"},"headline":"How to use Excel IF functions in Confluence","datePublished":"2023-11-17T11:43:59+00:00","dateModified":"2023-11-17T11:51:53+00:00","mainEntityOfPage":{"@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/"},"wordCount":251,"image":{"@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#primaryimage"},"thumbnailUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg","keywords":["Confluence","Inline Table Editing"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/","url":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/","name":"How to use Excel IF functions in Confluence - Actonic \u2013 Unfolding your potential","isPartOf":{"@id":"https:\/\/actonic.de\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#primaryimage"},"image":{"@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#primaryimage"},"thumbnailUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg","datePublished":"2023-11-17T11:43:59+00:00","dateModified":"2023-11-17T11:51:53+00:00","author":{"@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808"},"description":"Excel If functions in Confluence \u2714\ufe0f Inline Table Editing \u2714\ufe0f Calculations in view mode \u2714\ufe0f read now!","breadcrumb":{"@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#primaryimage","url":"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg","contentUrl":"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg","width":1200,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/actonic.de\/en\/how-to-use-excel-if-functions-in-confluence\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/actonic.de\/en\/"},{"@type":"ListItem","position":2,"name":"How to use Excel IF functions in Confluence"}]},{"@type":"WebSite","@id":"https:\/\/actonic.de\/en\/#website","url":"https:\/\/actonic.de\/en\/","name":"Actonic \u2013 Unfolding your potential","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/actonic.de\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/actonic.de\/en\/#\/schema\/person\/c700b8aadff4de9c01f096c78149a808","name":"Patricia Modispacher","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/83f51d32f34328d5faa7ff0292d03497d7df01baf810b0dc95a98f9818a08b7b?s=96&d=mm&r=g","caption":"Patricia Modispacher"},"url":"https:\/\/actonic.de\/en\/author\/patricia-modispacher\/"}]}},"jetpack_featured_media_url":"https:\/\/actonic.de\/wp-content\/uploads\/2023\/11\/40-Excel-If-Functions-in-Confluence-EN.jpg","_links":{"self":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts\/11574","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/users\/15"}],"replies":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/comments?post=11574"}],"version-history":[{"count":0,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/posts\/11574\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media\/11577"}],"wp:attachment":[{"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/media?parent=11574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/categories?post=11574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/actonic.de\/en\/wp-json\/wp\/v2\/tags?post=11574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}