using an if statement with find to compute criteria

[HP RodNuclear]

I am working on a rather large spreadsheet and I am trying to do this:

=IF(LEFT(H2,FIND(" ",H2))>E2,N,Y)

However, when I enter that in, Excel gives me a VALUE error and I don't understand why.

I even tried just putting in =LEFT(H2,FIND(" ",H2))>E2, to see what it would give me and it gave me all TRUE values, even after visual inspection some values are in fact supposed to be false.

Basically, is there a way for Excel to combine the IF and the FIND functions to look at a value in a cell composed of a number and text and extract the number. Then once the number is extracted, compare that to a value in another cell and give me "Y" or "N" if the criteria is met or not?

Thanks.

Btw, I love this forum.

[martindwilson]

add a 0
LEFT(H2,FIND(" ",H2))+0>E2 left returns text so add 0 to make it a real number to compare with e2

[HP RodNuclear]

This worked without the IF statement. However, when I add the if statement, it continue to gives me the VALUE error.

[ConneXionLost]

You need to put quotes around your "N" and "Y":

Please Login or Register  to view this content.

Cheers,