Tip Calculator Template

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

Leave a Reply

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Read More »

FLOOR Function

The FLOOR function in Excel rounds a given number down to the nearest specified multiple. Unlike the MROUND function, the

Read More »
Scroll to Top