Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
It's so easily done with a formula:
A1: <starting number A2: <ending number A3: =(A2-A1)/A1 (which gives percent change when you format A3 as a percentage), that I suspect the designers didn't feel a separate function, with its overhead, was necessary. Note: One could also be a bit more efficient: A3: =A2/A1 - 1 again formatting A3 as a percentage. In article , "stephenm" wrote: I cannot find a formula to calculate the percentage change between two numbers. I can write a formula which gives the answer, but I'm curious why Excel doesn't have this formula in the drop down lists. Am I missing it? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change FORMAT | Excel Discussion (Misc queries) | |||
Cell Change Color - Need Help | New Users to Excel | |||
change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) |