Amend formula to include ISERROR
Hi,
can any please advise of the syntax required to amend the formula=DATEVALUE(TRIM(Input!B2))
Please Login or Register to view this content.to include ISERROR to prevent #VALUE! being returned.Please Login or Register to view this content.
Any assistance would be greatly appreciated
Many thanks in advance
Regards
Rob
Rob
=IFERROR(your_formula,"")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try...
Formula:
Please Login or Register to view this content.
Oops....Ali already provided it.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
IFERROR is preferred. But you must use ISERROR if you are using a pre-XL2007 version or saving as "xls". In that case:Originally Posted by robertguy
=IF(ISERROR(DATEVALUE(TRIM(Input!B2))), "", DATEVALUE(TRIM(Input!B2)))
Seeing as teh title is asking for ISERROR and not IFERROR, I would go with Joe's suggestion, otherwise IFERROR might be a better option.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks