Hide "False" Statement in a cell

[jpsouthwick]

I was wondering how to hide a "FALSE" statement in a cell which is displayed until a value is entered in other cells so that a calculation and total can be displayed which takes place of the "FALSE" statement.

 

[Norie]

Can you post the formula?

Generally something like this would work.

IF(A1=0, TRUE, "")

 

[UniMord]

I'm not sure what you're looking for exactly.

Do you want the cell to display "FALSE" until a value is entered elsewhere?
That would require a simple IF statement, e.g. if(a7 = "", FALSE, a7)

If you want the field to be blank until then, then you can still use an IF like this: if(a7 = "", "", a7)

Does this answer your question?

 

[jpsouthwick]

The function that I am using is this...

=IF(G7="M",I23,IF(G7="F",J23))

Until I enter in data in some of the required cells to come up with a total, the word "FALSE" is displayed in the cell. I am working with "Nested" IF statements... pretty cool, just learned about them

 

[jpsouthwick]

I just want to know what I need to do with my formula of

=IF(G7="M",I23,IF(G7="F",J23))

to get it so that the word "FALSE" is not displayed.

 

[Norie]

Maybe this?

=IF(G7="M",I23,IF(G7="F",J23, ""))