<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/a5a1e3ce-00fa-46e4-9a75-58c2aed9e8ce/Notion_Fundamentals_with_Thomas_Frank_-_Avatar_2021.png" width="40px" /> This example database is an extremely simplified tax calculator. It uses the Gross Income for each person to determine that person’s tax bracket, and outputs their total tax liability in the Total Tax property.

Note: This example uses the 2022 Federal income tax brackets, but does not include deductions, exemptions, or credits.

Created by Thomas Frank | Learn Notion Formulas | Notion Basics | Templates | Twitter

</aside>

Tax Calculator

let(
	gi, prop("Gross Income"),
	ifs(
		gi <= 10275, gi * 0.1,
		gi <= 41775, gi * 0.12 + 1027.5,
		gi <= 89075, gi * 0.22 + 4807.5,
		gi <= 170050, gi * 0.24 + 15213.5,
		gi <= 215950, gi * 0.32 + 34657.5, 
		gi <= 539900, gi * 0.35 + 49335.5, 
		gi * 0.37 + 162718
	)
)

© Thomas Frank