Need help for Excel formula - If and Or

[asdafgafawaaa]

Hi Excel Gurus,

I'm trying to write a formula in my report as below, but it only returns error "#VALUE!".

There are the scenarios:
If the value is a number or contains "-", equals L12
If else, leave it empty.

=IF(OR(ISNUMBER(E12),FIND("-",E12)>1),L12,"")
=IF(OR(ISNUMBER(E12)="TRUE",FIND("-",E12)>1),L12,"")

Can you please explain how to make it work?

Thank you in advance!

 

[Joe4]

The issue is that if FIND does not find anything, it returns an error.
Try this:

=IF(OR(ISNUMBER(E12),ISNUMBER(FIND("-",E12))),L12,"")

 

[Nine Zero]

Your first formula wont work if there is no hyphen in the number ... so basically wrap an iferror and set it to 0 if there is an error

=IF(OR(ISNUMBER(E12), IFERROR( FIND("-",E12),0)>1),L12,"")

 

[asdafgafawaaa]

Your first formula wont work if there is no hyphen in the number ... so basically wrap an iferror and set it to 0 if there is an error

=IF(OR(ISNUMBER(E12), IFERROR( FIND("-",E12),0)>1),L12,"")

Thank you very much, it works....

 

[asdafgafawaaa]

The issue is that if FIND does not find anything, it returns an error.
Try this:

=IF(OR(ISNUMBER(E12),ISNUMBER(FIND("-",E12))),L12,"")

Thank you very much, it works!!!