The OP could also use

=PRODUCT(D8,$B$2)

this will return zero if any text value is involved and won't choke on it

--

Regards,

Peo Sjoblom


"CLR" wrote in message
...

=IF(OR(ISTEXT(D8),ISBLANK(D8)),"",D8*$B$2) when placed in E8, says...

If EITHER D8 is text, OR D8 is blank, THEN leave E8 blank, OTHERWISE,
return
the result of D8 times B2

Vaya con Dios,
Chuck, CABGx3




"DJL" wrote:

Thank you so much for the quick reply. That worked beautifully!
Now can you tell me in plain english exactly what the formula says?