View Single Post
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.