ExcelBanter - #Value! cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - #Value! cell (https://www.excelbanter.com/excel-programming/440560-value-cell.html)

Oldjay

#Value! cell

I want to display a message in a cell if the cell returns #Value!

Paul C

#Value! cell

In Excel 2007 use the IFERROR
IFERROR(A1+b1,"You have an error")

in Excel 2003 IFERROR is not available, but you can use ISERROR
IF(ISERROR(A1+B1),"You have an error",A1+B1)

If you really want to get specific and only trigger on #VALUE and not all
errors check out the ERROR.TYPE function in help
--
If this helps, please remember to click yes.

"oldjay" wrote:

I want to display a message in a cell if the cell returns #Value!

All times are GMT +1. The time now is 11:54 AM.