If statement and running a command as a result of that

  • Thread starter Thread starter englishtwit
  • Start date Start date
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
 
Doh - just figured it out...

=if(E1234="Some text",MID(B1234,1,5),"Not relevent"
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula if/then and looking forwad - Please HELP 1
Return a cell reference as a result of an IF formula 1
If statement for a range of cells 3
IF STATEMENT including BLANK RESULT 2
formula for double If statements 4
IF and THEN statements 5
Three condition "if" statements 2
Multiple if statements 5

Back
Top