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.

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.

How to Make a Decision Table in Excel: 2 Easy Steps

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.

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.

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.

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.

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.

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 typed 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.

Practice Section

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

Download Practice Workbook

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

Make a Decision Table.xlsx

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.

<< Go Back to Make a Table | Excel Table | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!

2 Comments

Charles Morehead May 20, 2023 at 11:38 PM

Column 4 of the rules should be Yes, Yes, No.
- Reply
  Naimul Hasan Arif May 21, 2023 at 12:22 PM
  
  Dear CHARLES MOREHEAD,
  Thanks for your valuable suggestion. I have considered the suggestion and updated the article.
  Regards,
  Naimul Hasan Arif