up vote 1 down vote favorite

I have a calculated column called SUID # that pulls the value from a single line text input called SUID. The formula in SUID # is:

=RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)

If SUID is blank, the SUID # column will show #VALUE!

Is it possible to change that error text? I would like it to say "Please Enter the SUID Only on Package Pickup"

share|improve this question
up vote 1 down vote accepted

It'd be something like this:

=IF(ISERROR(RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1)),"Please Enter the SUID Only on Package Pickup",RIGHT(LEFT(SUID,INT(FIND("=",SUID)-1)),LEN(LEFT(SUID,INT(FIND("=",SUID)-1)))-1))

http://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx

share|improve this answer
  • This is perfect. I was trying that ISERROR syntax earlier, but couldn't get it right. Thank you! – nicolefdesigns Dec 18 '14 at 15:34
  • @nicolefdesigns kindly tick mark the answer to close the question :) – Arsalan Adam Khatri Dec 18 '14 at 15:35
  • @ArsalanAdamKhatri Since I'm a new user, I have a 5 minute wait time to be able to close the question. I think that is a bit ridiculous, but it can't be helped. – nicolefdesigns Dec 18 '14 at 15:36
  • ^ Yes I observed that feature in the beginning.. I'm sure there will be strong reason for it.. Some new users usually leave the question open even when answered, and closing questions can only be done by questioner so thanks.. :) – Arsalan Adam Khatri Dec 18 '14 at 15:40

Your Answer

 
discard

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Not the answer you're looking for? Browse other questions tagged or ask your own question.