The IF Functions - M. L. Humphrey
-20% with code BOOKS
Shipping in 10-16 days
30-day return policy
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, SUM ... Full description
You May Also Like
TOP
If Anyone Builds It, Everyone Dies: Why Superhuman AI Would Kill Us All
Eliezer Yudkowsky, Nate Soares
-20% with code BOOKS
In stock at our supplier
TOP
How To Think About AI: A Guide For The Perplexed
-20% with code BOOKS
In stock at our supplier
TOP
The 21st Century Brain: Cutting edge neuroscience to help us navigate the future
-20% with code BOOKS
Out of stock
TOP
Gödel, Escher, Bach: An Eternal Golden Braid
-20% with code BOOKS
In stock at our supplier
TOP
AI Engineering: Building Applications with Foundation Models
-20% with code BOOKS
In stock at our supplier
TOP
Empire of AI: Dreams and Nightmares in Sam Altman's OpenAI
-20% with code BOOKS
In stock at our supplier
TOP
The Rust Programming Language
Steve Klabnik, Carol Nichols, Chris Krycho
-20% with code BOOKS
In stock at our supplier
TOP
The Art of Game Design: A Book of Lenses
-20% with code BOOKS
In stock at our supplier
TOP
The Pragmatic Programmer: journey to mastery, 20th Anniversary Edition, 2/e: your journey to mastery, 20th Anniversary Edition
-20% with code BOOKS
In stock at our supplier
TOP
Python Crash Course: A Hands-On, Project-Based Introduction to Programming
-20% with code BOOKS
In stock at our supplier
TOP
HBR Guide to Generative AI for Managers
-20% with code BOOKS
In stock at our supplier
TOP
How to Talk to AI: (And How Not To)
-20% with code BOOKS
In stock at our supplier
TOP
Hackers. 25th Anniversary Edition: Heroes of the Computer Revolution
-20% with code BOOKS
In stock at our supplier
TOP
How Linux Works: What Every Superuser Should Know
-20% with code BOOKS
In stock at our supplier
TOP
Hands-On Large Language Models: Language Understanding and Generation
Maarten Grootendorst, Jay Alammar
-20% with code BOOKS
In stock at our supplier
TOP
Fundamentals of Software Architecture: A Modern Engineering Approach
-20% with code BOOKS
In stock at our supplier
TOP
Speak Data: Artists, Scientists, Thinkers, and Dreamers on How We Live Our Lives in Numbers
-20% with code BOOKS
In stock at our supplier
TOP
World of Warcraft Chronicle, Volume 2
-20% with code BOOKS
In stock at our supplier
TOP
Linux Basics for Hackers, 2nd Edition: Getting Started with Networking, Scripting, and Security in Kali
-20% with code BOOKS
In stock at our supplier
Description
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.
More Information
| Author | M. L. Humphrey |
|---|---|
| Publisher | M.L. Humphrey |
| Release year | 2019 |
| Cover type | Softcover |
| EAN | 9781950902330 |