The IF functions are some of the most powerful functions in Excel.
A basic IF function lets you build a simple decision tree so that you have one outcome under one set of circumstances and another outcome if those circumstances aren’t met. You can then nest IF functions to make a multi-level decision tree that covers as many different scenarios as you want. (Or close to it.)
Then there are the COUNTIFS, SUMIFS, and AVERAGEIFS functions that let you count, sum, or average a list of values, but only when your specified conditions are met.
Want to know how many customers you have in Nevada who bought widgets and spent over $50? You can do that.
Want to know how much you sold to those customers? You can do that, too.
And want to know what each one spent on average? Yep, that too.
So what are you waiting for? Learn the power of the IF functions today.
The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, IF functions are covered in 50 Useful Excel Functions.
"synopsis" may belong to another edition of this title.
M.L. Humphrey is a former stockbroker with a degree in Economics from Stanford and an MBA from Wharton who has spent close to twenty years as a regulator and consultant in the financial services industry.
"About this title" may belong to another edition of this title.
Seller: BargainBookStores, Grand Rapids, MI, U.S.A.
Paperback or Softback. Condition: New. The IF Functions 0.13. Book. Seller Inventory # BBS-9781950902330
Quantity: 5 available
Seller: Lucky's Textbooks, Dallas, TX, U.S.A.
Condition: New. Seller Inventory # ABLIING23Mar3012140059209
Quantity: Over 20 available
Seller: PBShop.store US, Wood Dale, IL, U.S.A.
PAP. Condition: New. New Book. Shipped from UK. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781950902330
Quantity: Over 20 available
Seller: Books Puddle, New York, NY, U.S.A.
Condition: New. pp. 48. Seller Inventory # 26382443873
Quantity: 4 available
Seller: PBShop.store UK, Fairford, GLOS, United Kingdom
PAP. Condition: New. New Book. Delivered from our UK warehouse in 4 to 14 business days. THIS BOOK IS PRINTED ON DEMAND. Established seller since 2000. Seller Inventory # L0-9781950902330
Quantity: Over 20 available
Seller: Russell Books, Victoria, BC, Canada
Softcover. Condition: New. Special order direct from the distributor. Seller Inventory # ING9781950902330
Quantity: Over 20 available
Seller: Majestic Books, Hounslow, United Kingdom
Condition: New. Print on Demand pp. 48. Seller Inventory # 381427390
Quantity: 4 available
Seller: THE SAINT BOOKSTORE, Southport, United Kingdom
Paperback / softback. Condition: New. This item is printed on demand. New copy - Usually dispatched within 5-9 working days 155. Seller Inventory # C9781950902330
Quantity: Over 20 available
Seller: Ria Christie Collections, Uxbridge, United Kingdom
Condition: New. In. Seller Inventory # ria9781950902330_new
Quantity: Over 20 available
Seller: AHA-BUCH GmbH, Einbeck, Germany
Taschenbuch. Condition: Neu. nach der Bestellung gedruckt Neuware - Printed after ordering - The IF functions are some of the most powerful functions in Excel. A basic IF function lets you build a simple decision tree so that you have one outcome under one set of circumstances and another outcome if those circumstances aren't met. You can then nest IF functions to make a multi-level decision tree that covers as many different scenarios as you want. (Or close to it.) Then there are the COUNTIFS, SUMIFS, and AVERAGEIFS functions that let you count, sum, or average a list of values, but only when your specified conditions are met. Want to know how many customers you have in Nevada who bought widgets and spent over $50 You can do that. Want to know how much you sold to those customers You can do that, too. And want to know what each one spent on average Yep, that too. So what are you waiting for Learn the power of the IF functions today. The Easy Excel Essentials series of titles are meant to cover one specific topic of interest to users who know the basics of how to navigate Excel but want to increase their knowledge in that one particular area. If you want to increase your Excel knowledge in a more general way, see the Excel Essentials series which consists of Excel for Beginners, Intermediate Excel, and 50 Useful Excel Functions. In that series, IF functions are covered in 50 Useful Excel Functions. Seller Inventory # 9781950902330
Quantity: 1 available