| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
This doesn't look right to me
=IF(ISERROR(((B2-C2)*100/B2)),0,((B2-C2)*100/B2))
-- Gary''s Student - gsnu200795 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
