Home > Forum Home > Analyzing Corporate Financial Data > VALUE! > Using formula error catching Share

Using formula error catching

Excel Help for Using Formula Error Catching in Analyzing Corporate Financial Data

Forum TopicLogin

Using Formula Error Catching

Rate this:
(3/5 from 1 vote)
OopsTo catch formula errors and return alternative values you can use the ISERROR function to catch any errors and replace the VALUE! with a blank or any other value such as zero.

Support your formula is A1/A2, then the formula would be:
 Excel Business Forums Administrator
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for Using formula error catching in the