# Hide "False" Statement in a cell

#### jpsouthwick

##### New Member
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.

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Can you post the formula?

Generally something like this would work.

IF(A1=0, TRUE, "")

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)

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

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.

Maybe this?
Code:
``=IF(G7="M",I23,IF(G7="F",J23, ""))``

Replies
13
Views
210
Replies
7
Views
320
Replies
6
Views
198
Replies
2
Views
240
Replies
5
Views
262

1,214,744
Messages
6,121,278
Members
449,021
Latest member
bob_messenger

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back