There is probably some text character, like a space in the cell D8

=IF(OR(ISTEXT(D8),ISBLANK(D8)),"",D8*$B$2)

Vaya con Dios,
Chuck, CABGx3



"DJL" wrote:

in cell E8 I have this formula: =IF(ISBLANK(D8),"",D8*$B$2)
I get the #VALUE! error.
Can someone tell me why and how I can correct it.
I am just trying to say that if D8 is empty don't show anything, if
populated multiply D8 by B2.

Thank you for your help


--
Diana