IF Statement Help

[jemmers]

Hello All,

I'm trying to figure out an IF statement which is driving me batty. What I'm wanting done is to NOT display a record if the value of a cell is true. I only want the false ones. This isn't strictly in Excel, but it accepts the same type of logic. I wish I had an example to upload, but this time, I do not. The calculations would be in a single cell though, and would not need to reference any others.

Thank you.

[etaf]

=if( cell = TRUE , "", Cell to display)

so if you want to display say B2
and
in B1 you have true or false

then
=IF( B1=TRUE, "", B2)

[jemmers]

Perfect, thank you!

[etaf]

your welcome
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.