ERROR.TYPE

[joenjoe]

I have a cell that, depending on if something is entered elsewhere, will either produce a value or #VALUE!. I use the following formula in yet another cell to try and have either the value from the first cell display or nothing at all:

=IF(ERROR.TYPE(A6)=3, "", A6)

This either produces a blank (which is OK when nothing is entered) or #N/A! (instead of the desired value). I actually copied, pasted, and modified this formula directly from the Excel Help file.

Does anyone have any idea what I might be doing wrong or have a suggestion of an entirely different formula to achieve my desired results?

 

[tactps]

Welcome.

Try:
=if(iserror(a6),"",a6)
which will use blank for all errors

 

[tactps]

Even better, change your formula in A6 to not show errors in the first place.

 

[joenjoe]

Thank you tactps,

You are awesome!!! That worked perfectly. Thanks to you I will be able to sleep tonight.