Excel's IF statement made easy

May 12, 2017

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 the formula bar.In particular, there’s the IF statement, which generates by far the most Excel-related queries to Answer Line. But once you’re familiar with it, it’s a breeze. At least for simple stuff.[Have a tech question? Send your query to answer@pcworld.com.]Just like ordering lunch Logic in programming or formulas is no different from deciding where to go and what to eat for lunch. If Harry’s is open, then we’ll go there, and I’ll have the Caesar’s salad. If Harry’s is closed, then let’s eat at Harriet’s and there’s a turkey burger that’s not too heavy. If both are closed, to heck with it, I’m doubling down on a Whopper meal.To read this article in full or to leave a comment, please click here

Link: http://www.pcworld.com/article/3190705/software/excels-if-statement-made-easy.html#tk.rss_howto