Need a ) somewhere in ISERROR formula but don't know where to put it

L

lhkittle

I have this working formula in N8 =LEFT(R8,FIND(":",R8))

Sometimes R8 has a string with no : and N8 returns #VALUE.

I want if N8 returns #VALUE then N8=""

I can get this far and don't know where the ) is supposed to go (from error alert box)so I can complete Value if True and Value if False

=IF(ISERROR(LEFT((R8,FIND(":",R8)) ??

Thanks,
Howard
 
C

Claus Busch

Hi Howard,

Am Mon, 16 Dec 2013 06:18:03 -0800 (PST) schrieb (e-mail address removed):
=IF(ISERROR(LEFT((R8,FIND(":",R8)) ??

try:
=IFERROR(LEFT(R8,FIND(":",R8)),"")
or
=IF(ISERROR(LEFT(R8,FIND(":",R8))),"",LEFT(R8,FIND(":",R8)))


Regards
Claus B.
 
L

lhkittle

Hi Howard,



Am Mon, 16 Dec 2013 06:18:03 -0800 (PST) schrieb (e-mail address removed):






try:

=IFERROR(LEFT(R8,FIND(":",R8)),"")

or

=IF(ISERROR(LEFT(R8,FIND(":",R8))),"",LEFT(R8,FIND(":",R8)))





Regards

Claus B.

--

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2

I used the short one, works fine.

Guess I should remember I have Excel 2010 and the IFERROR.

Thanks.
Regards,
Howard
 
C

Claus Busch

Hi Howard,

Am Mon, 16 Dec 2013 06:45:41 -0800 (PST) schrieb (e-mail address removed):
I used the short one, works fine.

another suggestion:
=IF(ISNUMBER(FIND(":",R8)),LEFT(R8,FIND(":",R8)),"")


Regards
Claus B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top