If function for text values

[Ehezve]

I would like the following to occur in a spreadsheet I am working with,

If contents of D5 is greater than or equal to 5, then contents in M5 should output 'Yes'
If contents of D5 is less than or equal to 5, then contents in M5 should output 'No'

However contents in D5 is both numerical & text e.g. 1 - Low; 7 - Moderate ......

Can you please asist me with coming up with the correct formulaes that will allow me to achieve the above?

I currently have the following formula and its working well when I use only numbers in D5 and not both numbers and text.
=IF(D5<=5,"No","Yes")

If I change the formula to =IF(D5="Low","No","Yes") it gives me an error.

Any assistance will be sincerely appreciated.

[alansidman]

=if(Left(D5,1)<=5,"No","Yes")

Try the above

[:) Sixthsense :)]

May be this...

In M5 Cell

=IF(ISNUMBER(VALUE(LEFT(D5,FIND("-",D5)-1))),IF(VALUE(LEFT(D5,FIND("-",D5)-1))>=5,"Yes","No"),"")

[FDibbins]

Alan, =left() will always return text, so that wll always return YES, no matter the "value" is

[alansidman]

@FDibbins--Thanks. A sure sign its time for bed.

It should read: =IF(VALUE(LEFT(A1,1))<=5,"Yes","No")

Now to sleep. Perchance to dream.

[Ehezve]

Thank you so much Alan / Dibbins & Sixthsense. It worked perfectly well. Sincerely appreciate every help.