O'Reilly logo

Learn Excel 2011 for Mac by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Nesting One Function Inside Another Function

When you first start using functions, you'll probably use a single function in a cell. But as you become more experienced with functions, you'll find you sometimes need to use multiple functions to perform the calculations you want.

When you need to use two or more functions together, you can nest one function inside another function. For example, if you need to return the current hour, you can nest the NOW() function (which returns the current date and time) in the HOUR() function (which returns the hour from a given time in 24-hour format; change the cell format if you need the hour in AM/PM format):

=HOUR(NOW())

As with formulas, you can nest functions many layers deep if you need to. Here's an ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required