I use this guy quite a bit but is there a version that you can use to return something else if not an error
With the following high level logic =if(a1="#N/A","error","")
MQ
I use this guy quite a bit but is there a version that you can use to return something else if not an error
With the following high level logic =if(a1="#N/A","error","")
MQ
Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind.
Not sure what you're asking but based on your pseudo formula...
=IF(ISERROR(A1),"Error","")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
That's exactly what I mean.. Cheers
Or
=IF(ISNA(A1),"Error","")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks