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
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