You don't get #VALUE! if there is no data, but if there is text instead of a
number.
You may want to try =IF(COUNT(A2:B2)=2,A2*B2,"")
--
David Biddulph

"Wu" wrote in message
...
There are three column contain "Quantity" (A1), "Unit price" (B1) and
"Amount" (C1)

I have set a formula at "Amount" (C2)that =A2*B2, it is work , but if
anyone
of A2 or B2 is no data, or both of them are no data, C2 will show
#value!

How can it does not show #value! even there are no data at A2 and B2.