datacentralized
New Member
Hi guys, I am having a small problem with some column data. I have attached my document for those that can help.
For column "K" I am trying to calculate the price difference between the entry price and exit price using =(J2-I2)*E2. I have copied this to all the way down to "K32" and the formula DOES works if you enter the data, but is there a way to make it not show 0$ (stay blank) and only the correct answer once the user fills in all three fields J2 I2 E2?
Same thing for column "L". Currently it shows "#DIV/0!" unless user enters entry price and exit price. Is there a way to stay blank and only show the percentage once user fills in both fields? Thanking you all in advance for the help.
For column "K" I am trying to calculate the price difference between the entry price and exit price using =(J2-I2)*E2. I have copied this to all the way down to "K32" and the formula DOES works if you enter the data, but is there a way to make it not show 0$ (stay blank) and only the correct answer once the user fills in all three fields J2 I2 E2?
Same thing for column "L". Currently it shows "#DIV/0!" unless user enters entry price and exit price. Is there a way to stay blank and only show the percentage once user fills in both fields? Thanking you all in advance for the help.