iserror | Excel & VBA

Hide Error Value and Error Indicators in Excel

To hide error value and error indicators in Excel you can use any of the following means: Hide error values using conditional formatting Hide errors indicators by turning off background error Hide error values by using IF(ISERROR()) function Hide error using a custom VBA function Let's take a closer look at each type of error handling method. Hide error values using conditional formatting Click on the cell that contains an error value. From the menu, select 'Format' ...

60 Useful Excel Formulas That Are Good To Know

Posted on 23 August 2008

60 useful excel formulas that are a good to know DATE = Returns the serial number of a particular date DATEVALUE = Converts a date in the form of text to a serial number DAY = Converts a serial number to a day of the month EOMONTH = Returns the serial number of the last day of the month before or after a specified number of months MONTH = Converts a serial number to a month NOW = ...

Comments (1)

20 Useful Excel Formulas You Must Know

Posted on 23 August 2008

20 Excel formulas you should know DATEVALUE = Converts a date in the form of text to a serial number DAY = Converts a serial number to a day of the month MONTH = Converts a serial number to a month YEAR = Converts a serial number to a year LEFT = Returns the leftmost characters from a text value LEN = Returns the number of characters in a text string RIGHT = Returns the rightmost characters from ...

Comments (2)