LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!!!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating percentages tssjhs Excel Worksheet Functions 2 January 25th 05 01:56 PM
need help w/formula for calculating overtime hours jv749297 Excel Worksheet Functions 1 January 17th 05 07:54 PM
Add up a Dynamic Range with 2 Variables John Excel Worksheet Functions 1 January 15th 05 02:23 PM
Add up a Dynamic Range with 2 Variables John Excel Worksheet Functions 0 January 15th 05 02:00 PM
Index Match With 3 Variables Scooterdog Excel Worksheet Functions 5 January 2nd 05 07:05 PM


All times are GMT +1. The time now is 02:06 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"