=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?