#VALUE! is popping up

I have a list of 50 numbers which vary on length of new data.

The coding I'm using is:

=IF(--ISODD(LEFT(AO41))+(--ISODD(MID(AO41,2,1)))+(--ISODD(RIGHT(AO41)))>1,AO41,"")

Whatever rows/cells within that list of 50 are without data #VALUE! pops up.

Any recommendations on how to eliminate that?

Assuming Excel 2008 has the IFERROR function...

Please Login or Register  to view this content.

If it doesn't then:

Please Login or Register  to view this content.