Is it posible to hide the formula till it is activated?

[kevsoulo]

Hello guys!

Hope this post finds you well.

I have a question. Is it possible to have the cell empty, without errasing the formula?

In my file you have the Section "time open". Its a simple formula. A-B, thats it. When i drag the formula down it automatically gives a result to all the cells, even if there's no information yet. Is it posible to change this, without having to drag the formula down everytime i put new info in?

esquema 1.xlsxfinal.JPG

[Fluff13]

How about

Please Login or Register  to view this content.

[kevsoulo]

Hey!

It worked! Thank you so much.

I have another question, If, instead of =E2-D2, i had something like (example): =IF(A3="BALL";B3-C3;C3-B3) . How could I drag this formula down without it giving me a 0 result in cells that have no information?

Kind regard

[AliGW]

Administrative Note:

Is your forum profile showing the version of Excel that you need this to work for? Last version is unclear ...

Members will tailor the solutions they offer to the version of Office (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your version is for Mac, please also state this.

The three most recent versions of Excel are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the release number in your profile (e.g. MS365 Version 2211). This is in the About Excel section further down the Account page.

Thanks.

[AliGW]

Try this:

=IF(A3="BALL";IF(B3-C3=0;"";B3-C3);IF(C3-B3=0;"";C3-B3))

[HansDouwe]

Another option where you don't have to adjust the formulas is the following:

Give the cells custom format: hh:mm:ss;;

After the second semicolon is indicated how 0 should be displayed.
There is nothing after the second semicolon, so the 0 (00:00:00) is made invisible.

[kevsoulo]

Hello Ali!

It worked, the only problem would be if the result is 0. If the result of those cells is 0 it is not going to appear. Is there a solution for this?

[Fluff13]

I would tend to use a custom cell format, but the formula would need to be

Please Login or Register  to view this content.

[HansDouwe]

Glad to help, thanks for the feedback in the rep .

[HansDouwe]

If the result of those cells is 0 it is not going to appear.

In this case custom format doesn't work either and is the formula of Fluff (Post #8) an option.

[kevsoulo]

Thank you very much for your help today Fluff!

[kevsoulo]

Thank you Hans for being so helpful!

[Fluff13]

Glad to help & thanks for the feedback.

[kevsoulo]

Hello Ali,

I'm sorry to bother you again. Attachment 803596

I did what you teach me to do. Now i want to have a simple line chart that does refresh automatically when i put new info. The thing is that those "blank" cells are worth 0. Is there a way so this doesnt happen?

Kind regards

[AliGW]

This is a completely different question.

Start a new thread with a suitably escriptive title in the appropriate forum section here: https://www.excelforum.com/excel-charting-and-pivots/

No further help to be offered in this thread.