## What is the factorial of 0.5 (0.5!)?

If you use Excel and enter the following formula: =FACT(0.5) the answer will be one. However, if you open a more rustic tool such as the Windows Calculator and try again, you will get 0.886226925510.

So, how can a tool such as the Windows calculator come up with the correct answer when Excel can only return 1? What about the factorial of 0.75 (0.75!)? Again, Excel returns 1 whereas the Windows calculator gets the correct answer: 0.919062526898

## Excel 2007: Inserting Formulas in a Flash

Here are some nice tricks on how to quickly insert formulas in Excel. Forget all that dragging of the fillhandle and stuff. With these tricks you will be inserting formulas in no time.

## Excel 2007: Diagonal Sum

In this tutorial I show you how to sum diagonally using an array formula. You will also learn how to add conditional formatting in order to track the diagonal being summed.

## Excel 2007: Highlight Active Row (Take 2 – Part 2)

Here’s a cool way to highlight the active row in Excel (all sheets). This is done using Excel 2007, but it also applies to previous versions of Excel.

## Excel 2007: Highlight Active Row (Take 2 – Part 1)

Here’s a cool way to highlight the active row in Excel (all sheets). This is done using Excel 2007, but it also applies to previous versions of Excel.

## Excel: How to return names of files located in a folder

In this short tip, I describe how you can return the names of files located in a folder without using VBA.

This is a very neat and easy trick to perform.

## Excel 2007: Highlight Active Row

Here’s a cool way to highlight the active row in Excel. This is done using Excel 2007, but it also applies to previous versions of Excel.