© David Slager and Annette Slager 2020
D. Slager, A. SlagerEssential Excel 2019https://doi.org/10.1007/978-1-4842-6209-2_8

8. Excel’s Pre-existing Functions

David Slager1  and Annette Slager1
(1)
Fort Wayne, IN, USA
 

This chapter covers some of the most used functions that allow you to do such things as sum values only if they meet certain conditions, something based on whether a condition is true or not, determine the number of days between dates, get the current date and time, and so on. You will learn how to enter functions manually or by using the Function wizard.

After reading and working through this chapter, you should be able to
  • Create a nested function

  • Use the Function wizard

  • Find the number of days between two days

  • Sum a range of values based ...

Get Essential Excel 2019: A Step-By-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.