The
advent of Excel 2013 brought with it many new or enhanced features that users
have wanted for a long time. Among those
were Several
Cool Functions. Now, Excel 2013
is certainly not New anymore, but some of the functions that were first
introduced in this version are worth a closer look.
ISFORMULA()
This
function serves as a new informational tool. If you wish to quickly know
whether a cell or range of cells contain a formula, using this function returns
TRUE
if the cell contains a formula and FALSE if not. Knowing the difference
between data that was merely Entered and that which was Calculated,
can serve as important referential purposes.
SHEETS()
You
can use the Count property VBA to give you the number of sheets in the
current workbook, but who wants to mess around with VBA if you don’t have to!
(apologies to my very geeky friends…). The
new SHEETS()
function makes it slick and easy to obtain this information without
having to resort to more difficult solutions.
DAYS()
The
DAYS() function returns the number of days between two dates. Simple as that. Now this information has previously been
available by merely subtracting the StartDate from the EndDate, but this
function provides the ability to combine this floating data with
other functions with a more minimalistic, elegant approach.
ISFORMULA(), SHEETS(), and DAYS(),
all worthy of your attention when the time is right. Good stuff…
No comments:
Post a Comment