Tag: function

The Vlookup function is one of the most popular lookup functions in Excel. Join the channel Telegram of the AnonyViet ...

When concatenating text and a number, use the TEXT function in Excel to format that number. Join the channel Telegram ...

Using the CONCATENATE function in Excel for string concatenation. Instead of using CONCATENATE, you can also use the & operator. ...

To find the current date in Excel, use the TODAY function. To enter the current date and time, use the ...

This article will show you how to get a day of the week in Excel using the Weekday function and ...

The ADDRESS function in Excel generate cell references as text, based on a certain number of rows and columns. Join ...

Using the IFS function in Excel 2016 or later when you have multiple conditions. The IFS function returns a value ...

This example shows you how to use the function SWITCH ONLY in Excel 2016 and later instead of the IFS ...

ABS function in Excel Returns the absolute value of a number. In other words: the ABS function removes the minus ...

In this article, I will show you how to use the Sumproduct function to calculate the total amount of products ...