| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How would I do this?
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How would I do this?
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How would I do this?
Format C1 as Percent and put in =(A1-B1)/A1
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How would I do this?
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. "Mike H." wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How would I do this?
Thank you!
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
