SimonSezIT.com - We Teach IT. You Learn IT.

Tips, podcasts, advice and free video tutorials.

Entries Tagged ‘Excel Functions’

Using the Nested IF Function With Excel 2007

During in our previous tutorial, we discussed how to use the IF Statement. Let’s make it a little more complicated by using the Nested IF function in Excel. The Nested IF function extends the power of the IF statement, allowing you to create Excel reports and spreadsheets that are even more detailed and granular.
Creating logical [...]

How to Use the IF Function in Excel 2007

The IF function in Excel 2007 is the single most powerful command for the non-programmer using Excel. It is a real powerhouse! Using the Excel IF functions offers a quick and easy method to create logical arguments with the end result of presenting and your analyzing your data from a different perspective.
Creating logical functions [...]