| 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 Topic | Login |
Using Formula Error Catching | Rate this: (3/5 from 1 vote) |
 | To 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: =IF(ISERROR(A1/A2),"",A1/A2) | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Using formula error catching in the Excel Business Solutions Directory |