Tag: Lesson

Excel store and calculate floating point numbers. Sometimes, the result of a formula is an approximation. Join the channel Telegram ...

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

This article will show you how to create an array formula to count errors in Excel. Join the channel Telegram ...

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

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

Functions Excel like SUM, COUNT, LARGE and MAX don't work if there are error cells in the range. However, you ...

FREQUENCY function in Excel calculates the frequency of occurrence of values ​​in the range you specify. You can also use ...

Using the IFERROR function in Excel to return an alternate result, such as text, when the formula fails. Join the ...

This article will explain how to calculate the standard deviation based on the entire population using the STDEV.P function in ...

Using the MODE function in Excel to find the number that appears most often in the list. Use MODE.MULT to ...