Tag: function

The IF function is one of the most used functions in Excel. So in this article, we will learn about ...

If you use Excel 365, use XLOOKUP instead of VLOOKUP. The XLOOKUP function is easier to use and has several ...

Using the IRR function in Excel to calculate the project's internal rate of return. The internal rate of return (IRR) ...

NPV function in Excel is used to calculate the present value of a series of future cash flows and subtracts ...

PMT function in Excel calculates the payment for a loan based on constant payments and a constant interest rate. Join ...

MOD function in Excel find remainder of division. For example, 10 divided by 2 leaves remainder 0, 11 divided by ...

Using function SEARCH in Excel to find the position of a substring in another string. Jaw SEARCH is not case ...

Using the FIND function in Excel to find the position of a substring in another string. The FIND function is ...

Using the IFNA function in Excel to replace the #N/A error with what you want. The IFNA function only catches ...

This article will guide you to use the IsError function in Excel. Join the channel Telegram of the AnonyViet 👉 ...