trying to fix formula to leave blank when no data entered

[JMITCH26]

Trying to get this to be blank when no data has been entered. Currently, if there is no data put in yet it puts up an L

=IF(A2="","",IF(A2>2500,"H","L"))

any help on this will be great.

 

[ONEMINUTETUTORIAL]

Thank you ONEMINUTETUTORIAL that works perfectly

Welcome...

 

[JMITCH26]

if i put mitch in I get H but, if I put the numbers in then I get the correct H or L now I just had it typed wrong

 

[Aladin Akyurek]

if i put mitch in I get H but, if I put the numbers in then I get the correct H or L now I just had it typed wrong

What I'm hinting at is: When one expects numerical input, one should better test for that instead of blanks... hence the suggestion:

=IF(ISNUMBER(A2),IF(A2>2500,"H","L"),"")

​