© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_8

8. Excel’s Pre-existing Functions

David Slager

(1)Fort Wayne, Indiana, 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 on no conditions, one condition, or multiple conditions ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.