View Single Post
  #1   Report Post  
tssjhs
 
Posts: n/a
Default Calculating Percentages with Variables

How can I set up a spread set to calculate percentages with variables. Such
as
12/31/04 % 01/31/05 % 02/28/05
312,112,345 789,789,159 421,951,753
7,895,359 6,125,359 7,123,456

I want to calculate the percentage of increase or decrease per month for
each officer. When I use B2: =C2/A2 - 1 its only calculating one
way, giving false percentage. I tried the =If(or, but am getting false
percentages with that formula as well. HELP!!!