I've searched a sea of results but haven't found a solid answer to my specific question. Hopefully someone can help me out. I'm using cells C2,D2, and E2. Here's what I'm after. In cell E2, if C2 is greater than D2, E2 must display C2-D2/C2x-100, or if C2 is less than D2, E2 must display C2-D2/C2x100. The formula for those interested is stocks, if the current price of a stock is less than the opening price of the stock, display the percentage decrease (negative number) and vice versa.
Recent Questions - Web Applications Stack Exchange · Aug 6, 2021
Calculate percentage change between two values
0Sign in to vote or save
This page did not load. You can still read it on the original site — the toolbar below keeps your place in the directory.
I've searched a sea of results but haven't found a solid answer to my specific question. Hopefully someone can help me out. I'm using cells C2,D2, and E2. Here's what I'm after. In cell E2, if C2 is greater than D2, E2 must display C2-D2/C2x-100, or if C2 is less than D2, E2 must display C2-D2/C2x100. The formula for those interested is stocks, if the current price of a stock is less than the…
Comments
Nothing yet. Say the first thing.
Sign in to join the conversation.