Excel IF With Multiple Conditions
AND and OR go inside IF, because they return TRUE or FALSE rather than answers. That one distinction untangles most of these formulas.
Read the article →
Productivity articles
Tips, systems and tools to get more done with less friction.
How to Combine Two Columns in Excel
Paste Special to Values before deleting the source columns. The formula only points at them.
Excel Conditional Formatting Based on Another Cell
Mixed references are the entire difficulty. $B2 highlights rows correctly; B2 scatters; $B$2 is all or nothing.
Google Sheets IMPORTRANGE Not Working
The #REF! you get first time is not a fault. Click the cell and press Allow access.
Why Your Excel SUM Is Not Working
SUM silently ignores text instead of erroring. That is why the total looks plausible and is simply wrong.
How to Split Cells in Excel
Insert blank columns first. Text to Columns overwrites whatever is beside your data, silently and with no undo prompt.
How to Make a Drop-Down List in Google Sheets
Use a range rather than typed items for anything you will maintain, and set the rule to reject input if the point is to restrict…
How to Freeze Panes in Excel
Select the first cell that should scroll. That one rule explains every case, including freezing rows and a column together.
How to Remove Spaces in Excel
If TRIM seems to do nothing on text that clearly has a space, the character is not a space. That case wastes the most time.