Excel Formulas showing Nothing in Result Cell

  • Thread starter Thread starter William Henry
  • Start date Start date
W

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.
 
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)
 
Back
Top