Hide "False" Statement in a cell

jpsouthwick

New Member
Joined
Nov 1, 2005
Messages
7
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, "")
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
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.
 
Upvote 0
Maybe this?
Code:
=IF(G7="M",I23,IF(G7="F",J23, ""))
 
Upvote 0

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top