View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default Calculating % when 0 is 100%

On Thu, 23 Feb 2006 04:07:27 -0800, Alison
wrote:

Hi, I am trying to calculate a % where 0 is 100%. I am trying to calculate
how far off each value is from 0 as a %...

Thanks,
Alison


If zero is your base, the percent difference of other values is not defined, so
far as I know.

If you describe in more detail what you are trying to do, perhaps a solution
will become apparent.
--ron