Formattin using if function

[managingcrap]

I want to create a function that when a text doesn't follow a foemat, then, the result is 0.

For example, the format is XXX-XXX. If the cell is 1234-a1, then, I should have zero.

If the text is 123-A1A, then, I'll have 1 as the output.

Please help. Ty

[AlKey]

Try this

Please Login or Register  to view this content.

v	A	B
1	1234-a1	0
2	123-A1A	1

[Tony Valko]

Here's another one...

=COUNTIF(A1,"???-???")

[Tony Valko]

=IF(ISERROR(SEARCH("???-???",A1)),0,1)

That returns 1 for entries like this:

123-123456789
123456789-123456

[AlKey]

That returns 1 for entries like this:

123-123456789
123456789-123456

Your examples Tony have nothing in common with what OP is asking for.

[Tony Valko]

We don't know that!

My interpretation is that the cell must contain a sting in the format XXX-XXX and nothing else.