View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Truncation or normalisation Truncation or normalisation is offline
external usenet poster
 
Posts: 1
Default How do i truncate a series to lie between 0 and 1?

Hey, I have two series. I want to get a ratio of their changes, but i want
the ratio to lie between 0 and 1. does anyone know how to do that?
someone suggested that i truncate or normalise. but i dont know how to.
please help.
Thanks