Formula combo

[ant]

Is there a way to combine these two formulas

=ISNUMBER(-LEFT(C2,2))

and

=IF(E2=TRUE,LEFT(C2,2),MID(C2,4,2))

please help

i done it once what lose the forumla

 

[Dan E]

Ant,

I'm sure that their is a way to combine them, but
a little more detail will be needed. Like....

Should be put the first formula in the second or
the second in the first???

What cells are each formula in???

Dan E

 

[ant]

The 1st formaula =ISNUMBER(-LEFT(C2,2)) should be first

than the other one

it look at info in cell c2

 

[Dan E]

I think I understand, test this formula and post back
if it's not what your looking for

=IF(ISNUMBER(-LEFT(C2,2))=TRUE,LEFT(C2,2),MID(C2,4,2))

 

[Immanuel]

Try the following:

=IF(ISNUMBER(-LEFT(C2,2)),IF(E2,LEFT(C2,2),MID(C2,4,2)),FALSE)

/i.