# Logic Calculations in Excel

### Make the most of TRUE and FALSE

You don’t have to use an IF function to get the most out of logic calculations in Excel.

Experience is the name everyone gives their mistakes.

Oscar Wilde (1854 – 1900)

| | Posted in Quotes

A great initiative by the University of Sydney to bring forward the use of a rating system for foods. Stay tuned for an App. Find out what’s healthy and what’s not.

Luck favours the mind that is prepared.

Louis Pasteur (1822 – 1895)

| | Posted in Quotes

# September 2014 Excel Yourself article

Check out my September 2014 Excel Yourself article, video and companion file are now online at the magazine site. The article covers converting a badly laid out report into a structured data layout using a formula.
The video can be viewed from the media section at the bottom of the page.

``` Related Posts Excel Power Query and Multiple Files 2023 Introduction to Excel Power Query 2023 Format As Table Webinar Recording 2023 Data Entry Formats in Excel [Video] One Minute to Excel #25 – Find the breakeven point ```

Curiosity is the key to creativity.

Akio Morita

| | Posted in Quotes

### Sort current table in order

To sort the current table by the selected column in ascending order, press in sequence

Alt H S S

Do not hold the keys down, press one after the other.

To sort in descending order use

Alt H S O

### Related Posts

| | Posted in Tips

Don’t find fault, find a remedy.

Henry Ford (1863-1947)

| | Posted in Quotes

# How to Identify Blank Cells in Excel

### Find the technique you need

When developing formulas in Excel you often need to know when a cell is blank. There are different ways to check if a cell is blank, the one you chose will depend on what you are trying to achieve.

### Format As Table

To apply the Format As Table option using the default format, select any cell within the table and use

Ctrl + T

Press Enter to confirm the range. Make sure the option “My table has headers” is ticked.

### Related Posts

| | Posted in Tips

Well done is better than well said.

Benjamin Franklin (1706-1790)

| | Posted in Quotes

# Excel Links and Deleted and Inserted Rows

### How to avoid #REF! errors

When linking to another sheet, a deleted row can often cause a #REF! error. You can use the INDEX function to avoid these errors.

A problem well stated is a problem half solved.

Charles Franklin Kettering 1876-1958

| | Posted in Quotes

Do not be afraid of defeat. You are never so near victory as when defeated in a good cause.

Henry Ward Beecher (1813 – 1887)

| | Posted in Quotes

Love not what you are, but what you may become.

Miguel de Cervantes (1547 – 1616)

| | Posted in Quotes

# Horizontal bullet chart in Excel

### Excel Yourself article

Check out my follow up article and VIDEO on the ITBDigital website on how to convert a vertical bullet chart into a horizontal one.

``` Related Posts Excel Bullet Charts [Video] How to Improve an Excel Line Chart [VIDEO] One Minute to Excel #28 – Eight More Charts in a Minute One Minute to Excel #27 – Eight Charts in a Minute Free Excel Webinar Recording – Financial Functions Part 1 ```