How would I do this?

[jwahlton]

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

 

[Mike H.]

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!

 

[Bob I]

Format C1 as Percent and put in =(A1-B1)/A1

 

[Mike H.]

One other thing, if you are going to have several people and you wish to have
lines for each person's weight loss each week, for example, I'd set up a
table of the people and their starting weight and instead of having E4 be
just a number, I'd make it a lookup to the table of people so you could
"bring in" the startweight.

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!

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

 

[jwahlton]

Thank you!