WEEKNUM Function of Excel – Finding Week Number

When we are working with dates in Excel, we might wish to know in which week of the year, this date falls. For example, what if I want to know in which week of the year my birthday comes?. This is going to be a very long calculation if I started counting the weeks from the beginning of the year. Thankfully, we don’t have to do it by ourselves when Excel has introduced the WEEKNUM Function.

In this tutorial we would learn how to calculate the week number of the date using the WEEKNUM formula in excel.

Here we go 😎

When to Use WEEKNUM Function of Excel

The word WEEKNUM represents “Week Number”. The function finds the number of the week on which a particular date falls. There are 365 days in a year (366 if leap year). When we divide 364 by 7 we get 52 complete years. The left 2 days might fall in the beginning or at the end of 52 complete weeks making the function to return the week number from 1 to 54.

The WEEKNUM formula forms part of the Date/Time Excel Function group.

Read moreWEEKNUM Function of Excel – Finding Week Number

TIME Function in Excel – Returning The Time Format

The TIME Function in excel makes sure of the particular required format. Whenever we are working with time in excel, we might be willing to perform calculations on time values. Let us see how does the function work.

In this tutorial, we would learn how to use the TIME formula in excel along with some examples. This blog is an exclusive blog about the excel’s TIME function.

Here we go 😎

When To Use TIME Function of Excel

The TIME Function in Excel is useful for representing time in a format of hh:mm AM/PM. It can also convert the seconds, months into hours. The function is useful in performing arithmetic operations on time when used with other excel functions.

The TIME function belongs to date/time functions group of Excel.

Syntax and Arguments

=TIME(hour,minute,second)

The following points explain the required function arguments for the TIME Function of Excel.

  • hour – In this argument, specify the numeric value of the hours. It can be a cell reference, a constant value or any other function like the HOUR formula of Excel.
  • minute – In this argument enter the numeric value of the minutes. This could be a cell reference, a constant numerical value or a function like the MINUTE formula of Excel.
  • second – In this argument enter the numeric value of seconds. It can be a cell reference, a constant numerical value or a function like the SECOND formula of Excel.

Read moreTIME Function in Excel – Returning The Time Format

ISREF Function in Excel – Checking for Cell Reference

A cell reference refers to the specific address of each cell in the spreadsheet. The column number is represented by alphabets from A to XFD while there is a serial number for each row in Excel. In the cell address, first comes the Column alphabet, and thereafter is the row number i.e A1 (cell where the column A and row 1 intersect). The ISREF Function of Excel is all about references.

These cell references can be the result of many other formulas like the OFFSET Function, INDEX Function, or INDIRECT Function. This is when the use of the ISREF comes.

Here we go 😎

When to Use Excel ISREF Formula

The word ISREF represents “Is it a cell reference?”. The ISREF function returns a logical TRUE or FALSE based on the condition if the passed argument is a cell reference, range of cells, or a named range.

This function can check if the result of any other formula is a cell reference or not. This function is categorized under the Information Functions of Excel.

Read moreISREF Function in Excel – Checking for Cell Reference

ISNUMBER Function of Excel – Checking If Cell Contains a Number

Many times, while working with numeric data in excel, we might feel a need to check if the cell contains a number or not. Manually going to each cell and checking if cell contains a numeric value is not a good option to go with. Interestingly, excel has an inbuilt formula to achieve this, viz. ISNUMBER function in excel.

In this tutorial, we would learn how to use the ISNUMBER excel function, using simple examples.

Here we go 😎

When To Use ISNUMBER Function of Excel

The expression ISNUMBER denotes “Is it a number?”.

To put it simply, the ISNUMBER formula of excel checks if the passed function arguments contain a numerical value or not. As a result, the function returns a logical TRUE if the cell contains a numerical value, else it returns a FALSE.

The ISNUMBER formula is a part of the Information Functions of Excel.,

Syntax and Arguments

=ISNUMBER(value)

The below point explain the required function argument for ISNUMBER Function.

  • value – In the value argument, specify a cell reference, the range of cells, or a formula result for which you want to check for the numerical value.

Read moreISNUMBER Function of Excel – Checking If Cell Contains a Number

ISNONTEXT Function of Excel – Check Non Text Cell in Excel

Many times, while working with data in Excel, you may as well feel a need to find the cell which is not in a text format cell in excel. In that case, the ISNONTEXT function in Excel becomes useful, to find non-text cell in excel.

In this tutorial, we would learn how to use the ISNONTEXT formula in excel and see how it works with the help of some classic examples.

Let’s deep dive. Here we go 😎

When to Use ISNONTEXT Function in Excel

The expression ISNONTEXT represents “Is the cell, a non-text value”. The excel ISNONTEXT formula returns a logical TRUE or FALSE based on the condition if the cell format is Non-text (i.e. a number, currency, accounting, date, time, percentage, fraction, scientific, etc.) or a text.

This function belongs to the Information functions group of excel.

The excel ISNONTEXT function works exactly opposite to the ISTEXT excel formula.

Read moreISNONTEXT Function of Excel – Check Non Text Cell in Excel

ISBLANK Function of Excel – Check if Cell is Blank

Many times, while analyzing the data in excel, we might be willing to work with the blank cells in the data. Out of the whole big data in excel, we may feel a need of finding only the blank cells using a formula. This is when the ISBLANK function of Excel comes into its use.

In this article, we would go through the ISBLANK formula in excel and cover all the aspects of this information function. This tutorial includes the purpose of excel ISBLANK formula, function syntax and argument, and examples.

Here we go 😎

When To Use ISBLANK Function in Excel

The expression ISBLANK denotes “Is the cell blank?”. ISBLANK formula of excel returns a TRUE or FALSE if the entered argument is a blank cell or a non-blank cell respectively. The function is categorized under the information functions group of Excel.

Whenever we want to highlight the blank cells in a range, ISBLANK Function comes into its use. We can use the function to perform conditional formatting as well as with other excel functions.

Read moreISBLANK Function of Excel – Check if Cell is Blank

ISTEXT Function in Excel – Checking if Cell Contains Text

Whenever we are working with data in Excel, we have to work with the cells set to text format. The text strings, numbers, date, time, or any value can be set to text format. In this tutorial, we would learn about how to use the ISTEXT Function in Excel to check if a particular cell contains a text or not.

Here we go 😎

When to Use ISTEXT Formula in Excel

The expression ISTEXT represents “Is it text?”. The ISTEXT excel formula helps us to check if the cell is set to a text format or not.

The function returns a ‘TRUE’ if the passed argument is in text format, otherwise, it returns a ‘FALSE’.

The ISTEXT Function is a part of the Information functions of Excel.

Usage of ISTEXT Function in Excel

The function when used with the SUM function of excel can count the total number of cells containing text.

We can also use this function before using the TEXTVALUE or DATEVALUE function to check for the text format. Check the TIMEVALUE Function blog (example 2) for that.

Many excel users use the ISTEXT function along with the data validation.

Syntax and Arguments

=ISTEXT(value)

The below point explain the required function argument for the ISTEXT Function of Excel.

  • value – In this argument represent the cell reference or the range of cells for which we want to check for text format.

Before going deep into how the excel ISTEXT formula works, let us see how to convert a cell format to text.

Read moreISTEXT Function in Excel – Checking if Cell Contains Text

ISNA Function in Excel – Checking for #N/A Errors

Many times, while searching for a value in the spreadsheet we have to deal with #N/A errors. Every time the function like VLOOKUP, HLOOKUP, MATCH, or XLOOKUP formula cannot find the results, it returns a #N/A error. For dealing with such #N/A errors in excel, the excel ISNA function becomes very useful.

In this tutorial, we would uncover the ISNA formula in excel and how it works with examples.

Here we go 😎

When to Use ISNA Function of Excel

The expression ISNA represents “Hey! Is it a #N/A error?”. The ISNA formula of Excel returns a logical value ‘TRUE’ or ‘FALSE’ based on the condition that whether the supplied argument returns #N/A error.

ISNA Formula belongs to the Information functions group of Excel.

Syntax and Arguements

=ISNA(value)

The below point explain the required function argument for the ISNA function of Excel.

  • value – This argument could be a cell reference, range of cells or a formula result in which we want to check the presence of #N/A error.

Read moreISNA Function in Excel – Checking for #N/A Errors

ISERROR Function in Excel – Checking for Errors

While working with the formulas in Excel, we may come across various kinds of excel formula errors. Therefore, we need to cope with these unwelcomed errors. Anything we can do to clean, count or represent those errors is by using the ISERROR Function of Excel. Let us see how.

Here we go 😎

When to Use ISERROR Function in Excel

The expression ISERROR represents “is there any error in the cell?”. The ISERROR formula in excel helps us know if the passed argument contains an error or not. The function returns a boolean TRUE for the erroneous cells.

Whereas, if there are no errors (i.e. cells containing text strings, numbers, or formulas), the excel ISERROR formula returns FALSE.

We can use the function to count the number of error messages, present the errors in a clean way, or highlight the erroneous cells.

This function is categorized under the Information functions of Excel.

Syntax and Arguments

=ISERROR(value)

The below point explains the value argument of the ISERROR function of excel.

  • value – In this argument, specify the cell, range or a formula result. The ISERROR function checks if the supplied argument contains or returns any error or not.

Read moreISERROR Function in Excel – Checking for Errors

ISERR Function in Excel – Checking If The Cell Contains An Error

While working with the excel functions, you may encounter some or the other excel formula error, which we need to fix. There are two functions that would help you to deal with the errors – ISERROR and ISERR function in excel. These two formulas are very similar, with a very slight difference.

In this blog, we would learn how to use the ISERR formula in excel to deal with errors.

Here we go 😎

When To Use the Excel ISERR Function.

The ISERR Function returns a boolean (i.e. TRUE or FALSE) based on the supplied argument result. The function belongs to the Information function group.

It is important to note that the ISERR function does not work with #N/A errors. This is one of the major differences between the ISERR and ISERROR excel functions.

What Does ISERR Function Return?

  • TRUE – The function returns TRUE when the function argument is an error like #NUM! , #NULL!, #NAME?, #VALUE!, #DIV/0! or #REF!.
  • FALSE – The ISERR formula returns a FALSE for the #N/A error or any other not an error cell value.

Syntax and Arguments

=ISERR(value)

The below point explain the required function argument for ISERR Formula.

  • value – In this argument, enter the cell reference, the result of a formula, or range of cells to check for the error.

Read moreISERR Function in Excel – Checking If The Cell Contains An Error

ISLOGICAL Function in Excel – Checking for Boolean TRUE/FALSE

The ISLOGICAL Function is a part of IS formula in excel. These functions are mainly used in dashboards interfaces.

There are two logical values in excel – TRUE and FALSE. In this tutorial we would learn how to use the ISLOGICAL function of Excel with self-explanatory examples.

Here we go 😎

When to Use ISLOGICAL Function of Excel

The expression ISLOGICAL represents “Is it logical?”. The ISLOGICAL function checks whether the supplied argument contains a logical value (TRUE/FALSE) or not. It returns a ‘TRUE’ if the function argument contains a logical value, else it returns a ‘FALSE’.

The ISLOGICAL Function can be categorized under the Information functions of Excel.

Syntax and Arguments

=ISLOGICAL(value)

  • value – In this argument, enter a number, text string (within double quotes), a formula result, cell reference, or a logical value for checking the condition (TRUE/FALSE).

Read moreISLOGICAL Function in Excel – Checking for Boolean TRUE/FALSE

TIMEVALUE Function in Excel – Returning Serial Number of Time

While working with date and time in Excel, we may sometimes feel a need of performing arithmetical calculations on the time. Unfortunately, excel cannot perform any calculations directly on the time format (HH:MM:SS). In such a scenario, the TIMEVALUE function in excel comes into its use.

The TIMEVALUE formula in excel is useful to convert the time in HH:MM:SS format into its decimal numerical value. This blog will explain to you the usage of the excel TIMEVALUE function.

Here we go 😎

When to Use TIMEVALUE Function Of Excel

The expression TIMEVALUE represents “Numerical value of time”. Sometimes, the time in excel is recognized by it in text format. The TIMEVALUE function in excel extracts the numerical value of time from this text value.

Therefore, the formula returns the decimal number. The numerical value ranges between 0.00 to 0.99999.

The excel TIMEVALUE formula is categorized under the date/time functions of excel.

Syntax and Arguments

=TIMEVALUE(time_text)

The below point explain the required function argument for the TIMEVALUE formula.

  • time_text – In this argument, specify the text value of the time. It could be a cell reference or the actual time enclosed in double quotes.

The function can also extract the time when both date and time are entered as the time_text argument.

Read moreTIMEVALUE Function in Excel – Returning Serial Number of Time