Excel Formulas showing Nothing in Result Cell

[William Henry]

How do I write a formula to display nothing in a Cell if
the Cell to be multipled has nothing in it,

eg Multiply A1*B1 = C1

10*2 = 20

0 * 5 = Blank??

Cell A1 is blank and cell B1 has 5 and the ansew is 0
which should show up as a blank cell.

Hope someone understands what I mean??

Thank you in anticipation.

 

[Bob Phillips]

William,

=IF(A1*B1<>0,A1*B1,"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peo Sjoblom]

=IF(A1="","",A1*B1)