Solved how to make a formula for percentages

January 14, 2014 at 10:35:15
Specs: Windows 7
Finding the percentage of attendance from last year to this year. Need to make a formula from 1 worksheet to another.

See More: how to make a formula for percentages

Report •

January 14, 2014 at 12:53:30
✔ Best Answer
Look here:

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)

where original_value represents the value that the percentage of change is based on, and new_value represents 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.

Report •
Related Solutions

Ask Question