View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] yzzozzy@gmail.com is offline
external usenet poster
 
Posts: 2
Default calculating product of 2 cells where 1 cell is in percentage

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.