Something like this?

=IF(ISNUMBER(A1),A1*B1,0)

--
Robin Hammond
www.enhanceddatasystems.com


"nxqviet" wrote in message
ups.com...
Hi all,

I have a spread sheet with a GetPivotData formula, where I also have an
if statement that replace 0 (zeros) to "" empty cells. This replacement
is critical for some formular to work, but it also make the black cells
not usable for any calculation. If I simply multiply one empty cell by
any number, it would show a #Value! error. How do I avoid this?

I tried Text (...,"#"), Value (...), neither work.

Thanks,

V_