tags:

views:

31

answers:

1
Q: 

Excel formula for variable fields

I am looking for a simple formula to do the calculation on two fields that are variable, for e.g., c1 has 100 and c3 has 150 and I want to calculate an increase/decrease percentage, but the trick is the cell values change every month. How do I put the formula to cater for such variation.

Appreciate your help.

Regards

A: 

Perhaps, I'm missing something, but taking your question literally, the answer is the following formula

=(C3-C1)/C3

You can format the cell containing this formula as a percentage if required.

AdamRalph  2010-03-24 07:24:59

related questions

Whats a good naming convention for large scope function variables?
Do you prefix your instance variable with 'this' in java ?
What is the best method to convert to an Integer in JavaScript?
Is a variable named i unacceptable?
.NET Integer vs Int16?
Finding the name of a variable in C
reinitialize system wide environment variable in linux
Pointer vs. Reference
Python-passing variable between classes
What kind of prefix do you use for member variables?
session variable mixup in ASP.NET?
Perl: variable scope issue with CGI & DBI modules
How might I pass variables through to cached content in PHP?
Print variable type in C++
How do I pass a variable to a mysql script?
is there a way to write macros with a variable argument list in visual C++?
How to determine the value of a controller variable during execution in Ruby on Rails?
In PHP is it possible to use a function inside a variable
Ruby - Get a Variable's Name
When do function-level static variables get allocated/initialized?
What's the best way to return multiple values from a function in Python?
How do you use script variables in PostgreSQL?
Comparing IEEE floats and doubles for equality
Accessing OpenGL state variables in Cg
PHP Variables passed by value or by reference?