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 ...