Format the cells that hold the body fat as PERCENTAGE

FormatCellsNumber tabPercentage

=D2*C2

Or, if you prefer, using the default GENERAL format

=D2*(C2/100)

Format as NUMBER 2 decimal places

--
Biff
Microsoft Excel MVP


"PJ" wrote in message
...
This is driving me nuts. I am a newbie at Excel.

I am trying to build a weight loss progress chart, and I need to
multiple body fat percentage column with body weight (e.g. 22 * 180).
So far so good, it's giving me 3960. But I need it as 39.60. The 22
should be taken as 22/100 and then multiplied by 180. When I tried
(C2*D2/100), its rounding the value to 40. I need 39.60. I don't want
to round it off.

Thanks in advance. I am a newbie and I searched all over but couldn;t
find an answer. May be I am searching incorrectly.