DEV Community

#spreadsheets

Posts

đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.
ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

ISBLANK is FALSE on a cell that looks empty (and IFBLANK doesn't exist) in Google Sheets

Comments
2 min read
How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

How to Find the Max Offer Price for a Rental Property in Excel or Google Sheets (Cash Flow, Cash-on-Cash, DSCR, Tested)

Comments
6 min read
How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

How to Calculate Your Estimated Tax Safe Harbor in Excel or Google Sheets (90% vs 100%/110%, Tested)

Comments
7 min read
VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

VLOOKUP returns #N/A but the value is right there: numbers stored as text and trailing spaces

Comments
2 min read
How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

How to Build a Rental Property Depreciation Schedule in Excel or Google Sheets (27.5 Years, Mid-Month, Tested)

Comments
7 min read
Invoice format in Excel: a simple layout with an optional tax % column

Invoice format in Excel: a simple layout with an optional tax % column

Comments
3 min read
Salary slip format in Excel: a printable payslip you fill from one register

Salary slip format in Excel: a printable payslip you fill from one register

Comments
3 min read
Order Tracking Spreadsheet for Online Sellers: Ship-By Dates, Late Orders and Profit per Order

Order Tracking Spreadsheet for Online Sellers: Ship-By Dates, Late Orders and Profit per Order

Comments
4 min read
A simple order and shipping tracker spreadsheet for small online sellers

A simple order and shipping tracker spreadsheet for small online sellers

Comments
2 min read
How to Build an Inventory Reorder Sheet for Resellers in Excel

How to Build an Inventory Reorder Sheet for Resellers in Excel

Comments
4 min read
A freelance income tracker spreadsheet: invoices, unpaid clients, and money set aside for tax

A freelance income tracker spreadsheet: invoices, unpaid clients, and money set aside for tax

1
Comments 1
2 min read
Turning a weekly meal plan into an aisle-sorted grocery list with plain spreadsheet formulas

Turning a weekly meal plan into an aisle-sorted grocery list with plain spreadsheet formulas

Comments
3 min read
How to Compare Standard Mileage vs Actual Car Expenses in Excel or Google Sheets (2026, Tested)

How to Compare Standard Mileage vs Actual Car Expenses in Excel or Google Sheets (2026, Tested)

Comments
6 min read
Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

Fix "Function ADD parameter 2 expects number values" (#VALUE!) in Google Sheets

Comments
3 min read
My XLSX converter learned that merged cells are a rumor, not a fact

My XLSX converter learned that merged cells are a rumor, not a fact

Comments
2 min read
đź‘‹ Sign in for the ability to sort posts by relevant, latest, or top.