Hello - I am looking to create a basic % Price Change formula with some IF/OR logic (I think that is the logic I need).
The criteria is if the prior price is 0 to show N/A. So my formula is as follows:
IF(U2=0,"N/A",(G2-U2)/U2)
Column U represents the prior day price
Column G represents the current day price
Now this works.
Next piece of logic I found is for certain type of instruments they price at a negative value. This is causing my formula to return the wrong sign. My thought was to nest in an OR statement to say:
=IF(OR(U2=0,"N/A",U2>0),(G2-U2)/U2),-(G2-U2)/U2)
However, this is not working.
Any idea how I can get this to pull in?
Here are some examples.
Security 123 - Prior price = 0 - Current price = 99.9153 = Result should be N/A
Security 456 - Prior price = -6.4327 - Current price = -6.7507 = Result should be -4.943%
Security 789 - Prior price = 23.28 - Current price = 22.80 = Result should be -2.062%
Thank you!
Bookmarks