Select Page

### QUESTION

$\LARGE&space;\fn_cm&space;\frac{939}{18,732}=5.01\%$

Problem: She was doing it in more than one step and was sure things could be more tidy.

Yes. This has a fairly easy solution but small things like this can irritate an Excel user to no end. Years ago, I would hide columns that had intermediate steps … and then I discovered that those types of columns have a name: HELPER COLUMNS

Congrats, Nicole! You’ve stumbled up on Helper Columns.

Here’s a screenshot of the issue:

NOTE: The Helper Column would be “Likes/Reach.” Such columns are useful when you have complex formulae that become a parentheses jungle. It is painful to build and troubleshoot such formulae so, breaking them into 2 or more steps is quite smart.

This formula is small so, let’s ditch the Helper Column.