Thread: Is Error Help on a formula
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
  
Posts: 5,939
Default Is Error Help on a formula
=if(A2 = "', "", =IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10))))
--
HTH...

Jim Thomlinson


"Jim" wrote:

Hello,

I need a little help changing this formula:

=IF(ISNUMBER(A2),A2,DATEVALUE(LEFT(A2,10)))

to return a blank if the referencing cell is blank. I appreciate the help.

jim
Reply With QuoteReply With Quote