Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating percentages | Excel Worksheet Functions | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Add up a Dynamic Range with 2 Variables | Excel Worksheet Functions | |||
Index Match With 3 Variables | Excel Worksheet Functions |