• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How do you hide formula field result until everything is filled?

Status
Not open for further replies.
D

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.
 

Attachments

  • Analysis_UPDATED.xlsx
    14.3 KB · Views: 0
datacentralized
Check from here ...

HELP! Formula to compare 2 Ranges + List reference from a different sheet

Hi guys, I am hoping someone can help me out here because I cannot for the life of me figure out what to do or if this is even possible.I have attached to this thread the workbook. I am using excel 2007. In my "Template" sheet I would like to analyze range combinations against a reference list...
chandoo.org
... please, do not duplicate
This thread is closed!
 
Status
Not open for further replies.
Back
Top