3 Easy Excel & Google Sheets Formulas to Split Expenses

Learn how to split expenses easily using Excel and Google Sheets formulas. Perfect for roommates, trips, and group expenses.

Introduction

Splitting expenses can be a hassle, but with these simple formulas, you'll be able to divide costs fairly and efficiently. Whether you're splitting rent with roommates or expenses from a group trip, these formulas will save you time and prevent errors.

Explanation:

•These formulas work in both Excel and Google Sheets
•They handle decimal places automatically
•They're perfect for recurring expenses

Basic Division Formula

=ROUND(A1/B1, 2)

Explanation:

•A1 is the total amount to split
•B1 is the number of people
•2 is the number of decimal places

Weighted Split Formula

=ROUND(A1*B1/SUM($B$1:$B$5), 2)

Explanation:

•A1 is the total amount to split
•B1 is the weight for the first person
•B1:B5 contains weights for all people
•This formula calculates proportional shares

Equal Split with Remainder

=IF(ROW()=1, ROUNDUP(A1/B1, 2), ROUNDDOWN(A1/B1, 2))

Explanation:

•A1 is the total amount to split
•B1 is the number of people
•First person gets rounded up amount
•Others get rounded down amount
•This ensures the total adds up exactly