Excel Tip Calculator

Learn to create a tip calculator template in Excel. This basic template allows you to setup a tip calculator for splitting up bills. It also allows you to split the bill between multiple people. Even your cheap friend will have to pay their fair share.

Begin by downloading the demo file.

Here is the tip calculator template will be be making.

tip calculator template
Tip Calculator

To use the template, make sure that you enter the Bill Amount in cell B4. Select the Tip% from the drop down menu. It is populated with 15%, 18%, and 20%. You can change this percentage by editing the drop down menu. As a reminder, their is different tipping etiquette around the world.

Select Cell B6. Edit this drop down menu by going to Data Tab – Data Validation drop down, then select Data Validation.

Data Validation Menu
Data Validation Menu

You will receive a pop-up menu. Select “List” from validation criteria.

tip calculator template
Data Validation Select List

We can now add additional percentages to the drop down list as shown. Make sure to add a comma between each additional option.

Data Validation Add to List