excel "" in function
 

I am using an =if function as follows: =IF(E8"",C8*D8,"")

Right now the formula only works if E8 contains a letter, I would like it
to work for a letter AND a number but cannot figure out how.

Any help would be appreciated.

Why not

=IF(E8<"",C8*D8,"")

HTH
Jason
Atlanta, GA

-----Original Message-----
I am using an =if function as follows: =IF
(E8"",C8*D8,"")

Right now the formula only works if E8 contains a
letter, I would like it
to work for a letter AND a number but cannot figure out
how.

Any help would be appreciated.
.

Here is one way, =IF(ISBLANK(E8),"",C8*D8)

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"drisok" wrote in message
...
I am using an =if function as follows: =IF(E8"",C8*D8,"")

Right now the formula only works if E8 contains a letter, I would like it
to work for a letter AND a number but cannot figure out how.

Any help would be appreciated.

Assuming you mean if E8 is NOT blank/empty

=IF(E8<"",C8*D8,"")

otherwise I don't know what you mean by E8 greater than ""


Regards,

Peo Sjoblom


"drisok" wrote:

I am using an =if function as follows: =IF(E8"",C8*D8,"")

Right now the formula only works if E8 contains a letter, I would like it
to work for a letter AND a number but cannot figure out how.

Any help would be appreciated.

Try =IF(E8<"",C8*D8,"")

Which means "not equal" rather then "greater than"


Gord Dibben Excel MVP


On Wed, 29 Dec 2004 13:17:01 -0800, drisok
wrote:

I am using an =if function as follows: =IF(E8"",C8*D8,"")

Right now the formula only works if E8 contains a letter, I would like it
to work for a letter AND a number but cannot figure out how.

Any help would be appreciated.