How to calculate percentage in 2 difference no

[Thiyagu8423]

Today. Before
30. 60. Formula (30-60)/30*100=-100

Today. Before
60. 30 Formula (60-30)/60*100=+50
Wrong value shown.i want formula to shown +100.
Basicly the formula should calculate both plus and minus percentage in single formula.

 

[pholt33]

 

[pholt33]

If you are trying to get the percentage change from prior day to today (like a stock price), then your general formula is (Today - yesterday) / yesterday * 100.
You have it as (today - yesterday) / today * 100 which uses the incorrect denominator.

 

[Thiyagu8423]

Hi pholt33.
Thanks for your formula..
Im looking for single formula that can be use for both condition.
Its for stock price..their is price higher than yesterday and some lower than yesterday in single colomn.i need one single formula that can calculate correct percentage drop or increase

 

[pholt33]

The general formula is always: (Today - yesterday) / yesterday * 100

 

[Thiyagu8423]

Hi pholt33.
Thanks for your formula..
Im looking for single formula that can be use for both condition.
Its for stock price..their is price higher than yesterday and some lower than yesterday in single colomn.i need one single formula that can calculate correct percentage drop or

 

[Thiyagu8423]

Thanks pholt33.
You formula work too