Excel Voodoo with Functions: IF, AND & OR!

Function: IF, AND & OR Want to know how to make your spreadsheet look like it’s a thinking being?  Looking for a way to make your data talk back to you? The most interesting aspect about Excel is the ability to execute logical equations or FUNCTIONS. IF One of my favourite functions is the IF function. Remember that this is a formula and as such, whenever you type it into a cell, you have to begin with a ‘=’ sign. The structure of the IF function has 3 parts and looks like this: =if(1. a logical or mathematical expression; usually referring to another cell, like if cell A1 is equal to 3 or if cell A1 is equal to cell B1, 2.then what you would like this cell to say or do if the expression indicated in 1. is true, 3. Lastly, what you would like this cell to say or do if the expression in 1. is false) Here’s

read more Excel Voodoo with Functions: IF, AND & OR!