<<<"this will return zero if any text value is involved"

Not really!
*Any* number in the range of Product() will be returned, not 0.

Can lead to some *possible* miscalculations.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Peo Sjoblom" wrote in message
...
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?