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.