IF functions in Excel are very useful but I've found the syntax to be a little tricky. I wanted to have an IF with more than two different outcomes, to do that you need to nest the IF statements. I discovered the following page which has a couple of easy to follow videos. I recommend it:http://office.microsoft.com/en-001/excel-help/using-more-than-one-if-function-RZ102425926.aspx
For Excel 2013, 2010, probably other versions too.
No comments:
Post a Comment