Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Make a Decision Table in Excel (with Easy Steps)

If You want to make a decision Table in Excel, you have come to the right place. Here, we will walk you through some easy steps to do the task effortlessly.

Download Practice Workbook

You can download the Excel file and practice while you are reading this article.


What Is a Decision Table?

A Decision table gives a firm procedure to represent complex business rules. It has an easy-to-understand layout. The Decision Table can be comprehended by business developers and its users smoothly. A Decision table has three sections, these are conditions, rules, and actions.


2 Easy Steps to Make a Decision Table in Excel

In the following table, you can see the Conditions, Rules, and Actions for Making a Decision Table. In the following article, using these Conditions, Rules, and Actions we will make a decision table. Here, we used Microsoft Excel 365. You can use any available Excel version.

Conditions, Rules, and Actions to Make a Decision Table in Excel

Step-1: Making Outline

In This step, we will make an outline for making our decision table.

  • To do so, first of all,  we used Borders to make an outline.

Therefore, you can see the structural outline for a decision table.

  • After that, we enter the Conditions in cells C6:C8.
  • Along with that, we enter the Actions in cell C9:C13.
  • Furthermore, we enter 4 employees in cell D5:G5.

Hence, you can see the complete outline of a Decision Table.

Outline to Make a Decision Table in Excel

Read More: Create Table in Excel Using Shortcut (8 Methods)

Step-2: Inputting Conditions and Actions in Decision Table

In this step, we will input the Conditions entry and Actions entry in the Decision Table.

  • In the beginning, we enter the Conditions entry in cells D6:G8.
  • Here, we put Yes if the condition is fulfilled, otherwise we put No.

Inputting Conditions to Make a Decision Table in Excel

After that, according to the condition, we will put a Tick mark as an Action entry.

Here, according to rule 1, If a person works for 40 hours in a week, then, he/she will get $400 dollars in a week.

Thus, we will put a Tick mark in cell D9, since employee 1 meets the first condition and, therefore, he/she will earn $400.

  • Afterward, to insert a Tick mark in cell D9, we will go to the Insert tab.
  • Furthermore, we from the Symbols group >> select the Symbols option.

Then, a Symbol dialog box will appear.

  • Furthermore, we will type Windings in the Font box.
  • Afterward, we will scroll down until we find a Tick mark >> select the Tick mark.
  • Then, click Insert >> click Close.

Inserting Tick Marks to Make a Decision Table in Excel

As a result, you can see the Tick mark in cell D9.

  • In a similar way, we put Tick marks in cells G10, F11, and E12.

Here, we put Tick marks only when the conditions are met.

Therefore, you can see a complete Decision Table.

Making a decision Table in Excel

Read More: How to Make a Conversion Table in Excel (8 Easy Examples)


Similar Readings


How to Make a Decision Tree in Excel

A Decision Tree is like a flowchart structure that represents conditions, rules, and actions in an easy way. A Decision Tree is used for classification and prediction.

Here, in the following table, you can see the Conditions, Rules, and Actions for Making a Decision Tree. After that, using these Conditions, Rules, and Actions we will make a decision tree.

Step-1: Inserting Rounded Corner Rectangle for Decision Tree

In this step, we will insert Rounded corner rectangles to input our Conditions, Rules, and Actions.

  • To insert a Rounded corner rectangle, first, we will go to the Insert tab >> select Shapes.

As a result, a number of Shapes will appear.

  • Then, we will select a Rounded corner rectangle.

  • Afterward, we will insert the Rounded corner rectangle.

Hence, you can see a Rounded corner rectangle.

Step-2: Formatting Shape

In this step, we will format the Rounded corner rectangle.

  • In the beginning, we will select the Rounded corner rectangle >> go to the Shape Format tab.

This will bring out several numbers of Theme Style.

  • Then, we will select the Theme according to our choices.

Hence, you can see the formatted Shape.

  • After that, we type Varsity Admission into our shape.

Thus, the first shape starts our discussion tree.

Step-3: Inserting Conditions and Actions Shapes

In this step, we will insert Conditions and Actions Shapes to make a Decision Tree.

  • Here, we followed Step-1 to insert the shapes, and Step-2 to format the shapes.

Therefore, you can see the Conditions and Actions Shapes of the Decision Tree.

Furthermore, we will connect the shapes with an arrow.

  • To do so, we will go to the Insert tab >> select Shapes.

As a result, a number of Shapes will appear.

  • Then, we will select a Line Arrow.

  • Afterward, inserting the Line Arrow, we will join the Varsity Admission shape with Condition shape Math Score = 80.

  • In a similar way, we connect all the Shapes with Line Arrows according to the Conditions and Actions.

Hence, you can see a complete Decision Tree.

Read More: How to Make a Table in Excel with Lines (with Easy Steps)


Practice Section

You can download the above Excel file to practice the explained method.


Conclusion

Here, we tried to show you some easy steps to make a decision table in Excel. Thank you for reading this article, we hope this was helpful. If you have any queries or suggestions, please let us know in the comment section below. Please visit our website Exceldemy to explore more.


Related Articles

Afia

Afia

Hello, I am Afia Aziz Kona. I graduated in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology (BUET). I have an immense interest in technical writing and content development, therefore, I am working as a content developer at Exceldemy. In my spare time, I travel, watch movies, and cook different dishes.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo