Here is the way I'd do it. If StartWeight is in E4, FinishWeight is in F4,
then:

=IF(ISERROR(((E4-F4)*100/E4)),0,((E4-F4)*100/E4))

This formula not only gives the right results, it avoids error messages for
unused rows that the formula appearas on. Just copy and paste it to use it.
And happy losing!


"jwahlton" wrote:

I'm trying to work on a weight loss spreadsheet. What would my forumula look
like if I needed to do this:

[(Start weight - Finish Weight) X 100 / Start weight = percentage lost.]

Thank you

Julia