if formula will not work 2

[sdelacey]

hi guys

Can anybody help. I am trying to write a formula that will copy a cell if the 4th char is /. I have written =IF(LEFT(B2,4)="/",""), but it does not seem to work. Can you please help me by telling me where I have gone wrong.

Cheers

Steph

 

[bluedragon2]

=IF(MID(B2,4,1)="/","")

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[bluedragon2]

sorry, hit submit before explaining:

If B2 is say abc/def

LEFT(B2,4) will give you abc/

MID(B2,4,1) will give you /

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Philly44]

The problem with the statement is you are setting the value to "" if it passes the test. An if statement like that reads =IF(test,value if true, value if false), your formula shouls be =IF(LEFT(B2,4)="/",B2,"")

 

[Philly44]

Sorry got ahead myself as well is should be
=IF(MID(B2,4,1)="/",B2,"")

 

[sdelacey]

Cheer's guys. I am a bit of a fool, thanks