Return #VALUE! as True or False

**BlastRanger** · 09-08-2010, 02:50 AM

Hi,
How can I convert a formula that has the result of #VALUE! into true or false?

for example,
a formula result is #N/A
using formula =if(isna(cell),"","Filled")
So all the cell with result of #N/A will be blank, those no #N/A will display Filled.

I want the same apply to #VALUE!
tried ISVALUE() but there are no formula of ISVALUE

**zbor** · 09-08-2010, 03:02 AM

You can try ISERR and ISERROR functions, but they use more than only VALUE error

**DonkeyOte** · 09-08-2010, 03:03 AM

It's not clear if you need to differentiate between #N/A and #VALUE! errors or not... you might want to review both ISERR and ISERROR functions in XL Help.
(there is no #VALUE! specific handler)