Finding the percentage of attendance from last year to this year. Need to make a formula from 1 worksheet to another.

Look here: http://support.microsoft.com/kb/214078

Stolen without permission from that website:

In Microsoft Excel, there is no built-in function to calculate the percentage of change from one value to another. However, you can use the following formula to calculate the percentage change:

=(new_value - original_value)/ABS(original_value)

whereoriginal_valuerepresents the value that the percentage of change is based on, andnew_valuerepresents the value that has changed.

You may also use the following alternate formula:

=(new_value/original_value) - 1

To display the resulting value as a percentage value, format the cell containing the formula with a percentage format.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Ask Your Question

Weekly Poll