This doesn't look right to me
 

I'm working on a weigh loss chart where it will figure out the percentage
lost each week.
This is the formula I was given to use:
=IF(ISERROR(((B2-C2)*100/C2)),0,((B2-C2)*100/C2))

And this is the result. I don't think that's right
JULIA 167.8 166.2 0.962695548

This doesn't look right to me
 

=IF(ISERROR(((B2-C2)*100/B2)),0,((B2-C2)*100/B2))
--
Gary''s Student - gsnu200795

This doesn't look right to me
 

And format the result as Percent

Regards,
Fred.

"Gary''s Student" wrote in message
...
=IF(ISERROR(((B2-C2)*100/B2)),0,((B2-C2)*100/B2))
--
Gary''s Student - gsnu200795

This doesn't look right to me
 

thanks!
--
Gary''s Student - gsnu200795


"Fred Smith" wrote:

And format the result as Percent

Regards,
Fred.

"Gary''s Student" wrote in message
...
=IF(ISERROR(((B2-C2)*100/B2)),0,((B2-C2)*100/B2))
--
Gary''s Student - gsnu200795