Thread: If (isnumber)

I'm using this formula -- =IF(ISNUMBER(SEARCH("-E",F2)),"E") -- and would like to add a second condition if F2 contains "-W" then return "W".

Is that possible?

Let me know if you need any additional info.

Thanks in advance.

Originally Posted by dilipandey

Hi bmoney,

Welcome to the forum.

Yes this is possible, use the following formula:-

=IF(ISNUMBER(SEARCH("-E",F2)),"E",IF(ISNUMBER(SEARCH("-W",F2)),"W",""))

Also, you did not mention what will be the output if the cell neither contains -E or -W. If you wish you can edit last two quotes ("") in the formula to have that thing into the picture.

Regards,
DILIPandey

<click on below 'star' if this helps>

If the cell contains "-E" then the output needs to be "E".

If the cell contains "-W" then the output needs to be "W".

Also:

If the cell contains neither "-E" or "-W" then the output needs to be "N/A".

Can you add that last command to the formula please?

Thanks!