If statement and running a command as a result of that

E

englishtwit

Hi Excelleans..

Well I enjoy my job, and can figure out most things, but I a
struggling again.

I would like an if statement in the cell that says something like:

=if(E1234="Some text",(MID,B1234,1,5),"Not relevent") and the resul
put into the cell you are in.

Look forward to your responses!

E
 
E

englishtwit

Doh - just figured it out...

=if(E1234="Some text",MID(B1234,1,5),"Not relevent"
 
Top