If cell is blank

[copeco]

Using Excel in the cell I4 , =If $H4>" ","ea"," &quot ???
what I'm trying to accomplish is:
if H4 is greater than a blank then put "ea" in I4
else I4 is blank.
The above formula works only if H4 has alpha charactors. I need it to work for numbers. ???...thanks

 

[vestax22]

Why do you have spaces between the quotations??

Try this =If $H4>"","ea","&quot

 

[bluedragon2]

=if($h4>0,"ea,"&quot

 

[bluedragon2]

sorry,

=IF($H4>0,"ea","&quot

 

[bluedragon2]

and if you want it to work with negative numbers:

=IF(H4>0,&quot;ea&quot;,IF(H4<0,&quot;ea&quot;,&quot;&quot)

 

[vestax22]

bluedragon


That wont detect a blank though

 

[vestax22]

=If(H4=&quot;&quot;;&quot;&quot;;if(H4>,&quot;ea&quot;,&quot;&quot

 

[bluedragon2]

or, if you want alpha numeric:

IF(H4=&quot;&quot;,&quot;&quot;,&quot;ea&quot

 

[bluedragon2]

They all work with blanks vestax, I was just giving a bunch of options as examples.

Blue

 

[vestax22]

You're right sorry bout that

 

[copeco]

Gents,
Thanks for the info. I have tried all of them, but alass, none of them seem to work. The only one that works is if a zero &quot;0&quot; is in the H4 cell. If it is blank it won't work.
Unless Vestax's... =If(H4=&quot;&quot;;&quot;&quot;;if(H4>,&quot;ea&quot;,&quot;&quot..may work but I keep getting a syntax after the = sign??

 

[bluedragon2]

what do you have H4 and I4 formatted as, they all work fine on mine.

On Vestax's, the ; should be ,

 

[copeco]

Gents,
My error. For some reason it didn't work b/4.
The =IF(I6>&quot;&quot;,&quot;&quot;,&quot;ea&quot formula works fine. I quess I syntax erored it or something....thanks much guys!!!!!!!!!1

 

[Wray69]

could just use;

=IF(ISBLANK(H4),&quot;ea&quot;,&quot; &quot

Regards,

Wray