## 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: Show image according to chosen name

Here’s a nice trick on how to swap images using a list and the camera tool without the need to use VBA. Consider you have a product list and wish to show a picture according to the selected product: well, here’s the solution!

## 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: 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.