Try something like this (depending on which format method you chose to use
for C2):

=IF(COUNT(C2:D2)<2,"",D2*C2)

=IF(COUNT(C2:D2)<2,"",D2*(C2/100))

--
Biff
Microsoft Excel MVP


wrote in message
...
Thank you so much. It worked.

Now I dragged the cell all the way down for other rows to be applied
the same formula and they all showed up as 0.00. Can I get rid of
"0.00" and leave the cell blank? I want it show up only if I entered
body fat % and weight columns.

Once again thanks.