PC World

Excel’s IF statement made easy

Excel is many things: powerful, useful, colorful, handy, but its logic functions can be challenging to newcomers due to their implied logic, and a shorthand syntax designed to fit on a single line in ...
Hosted on MSN

If you’re still nesting IFs in Excel, you’re doing it the hard way

Nested IF statements used to be my go-to whenever I needed to juggle multiple conditions in Excel. However, just because they get the job done doesn’t mean they’re the best tool for the job. Wrestling ...
MUO on MSN

Old Excel functions you should stop using (and what to replace them with)

VLOOKUP has been the go-to function for looking up data in Excel for years, but it comes with limitations. You can only ...
Ars Technica

Excel - can IF/AND statements question.

Excel - can IF/AND statements question. fuel4me Feb 15, 2011 Jump to latest Follow Reply ...
Ars Technica

Excel - problem with VLOOKUP in conditional IF statement formula

Hi there, currently tearing my hair out over this problem : <br><br>I have a spreadsheet that is meant to show who has completed certain training courses. Sheet1 contains the name of the trainees and ...