Is Error Help on a formula
A couple of other options. The previous formula will show a 0 if A2 is
blank. If you don't want to see a zero then, modify it just a tad:
=IF(ISBLANK(A2),"",IF(ISNUMBER(A2),A2,DATEVALUE(LE FT(A2,10))))
or if you don't mind seeing a zero when A2 is blank, then we can tighten it
up a little this way:
=IF(OR(ISBLANK(A2),ISNUMBER(A2)),A2,DATEVALUE(LEFT (A2,10)))
"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
|