Hi,
I want excel to show me that the change in percentage for this price result is negative;
Starting price: 60.61
Ending price: 48.97
There is a 19.2% decrease and I would like it to show in the cell: -19.2%
The other way around:
Starting price: 48.97
Ending price: 6061
There is a 23.77% increase and I would like it to show in the cell: 23.77%
The formula I am using:
Regards
I want excel to show me that the change in percentage for this price result is negative;
Starting price: 60.61
Ending price: 48.97
There is a 19.2% decrease and I would like it to show in the cell: -19.2%
The other way around:
Starting price: 48.97
Ending price: 6061
There is a 23.77% increase and I would like it to show in the cell: 23.77%
The formula I am using:
Regards