Select Page

## #4 of the Top 5 Functions: IFERROR

#4 in the List of Top 5 Functions: IFERROR Q:  What do an acrobat and Excel’s IFERROR function have in common? A:  An acrobat and an Excel user who employs IFERROR are both expressing: it’s risky but I know what I’m doing and I do it with elegance...

## Excel Percents, IFERROR, Helper Columns & Tidiness

QUESTION Nicole wanted to clean up a spreadsheet. She already had an answer to the math: 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...

## Dropdown Drama: Dependent & Dynamic Dropdown Lists

THREE people in the past 24 hours have had DROPDOWN DRAMA! But there are easy solutions. We just need to relax.  QUESTION Cheryl maintains clean data, by using dropdown lists to control data entry. But there’s a problem she describes: “Oh! I hate it when I...

## Text Format: Excel Keeps Turning My Data Into Dates

QUESTION Joy wants to type 2 – 8 into Excel and 8-FEB is what she keeps getting. No. Joy doesn’t want a date, she’s already married. The goal is to offer a range of options, one of them being 2 – 8 2 – 8 Hours 2 – 8 Vehicles 2...

## Control the X-Axis: start at 62 instead of 0

QUESTION: This question was submitted by Frank. He wants to know: How do we control the x-axis and get the line chart to use the ages 62 to 100-ish on the x-axis? The graph takes our range of 62 – 100 and turns the x-axis into 0 to 100?   ANSWER Sometimes...