entering a Boolean value into a cell

[Trebor777]

Hi, I want a cell to contain, and show, a logical True or False value, so that I can test it elsewhere with a simple IF(A1) .....

I've Googled around a bit, but am getting confused (brain like cabbage).

What is the simplest way of entering a simple True / False value into a cell please.

Thanks as always

K

[63falcondude]

TRUE and FALSE

or

1 and 0

[Trebor777]

just as text ?, in a general format ?

[63falcondude]

just as text ?, in a general format ?

General format, yes.

[Richard Buttrey]

If that's an 'OR' request and you mean that you want a cell to show either a True or a False then self evidently that cell needs to contain a formula that returns either a True or False.

e.g. for say A1:

Please Login or Register  to view this content.

will return a True if B1 is > C1 or False if not.

But if you then want to use A1 as the subject of a test, why not instead just use the formula that is in A1?
It seems to me that you don't actually need an A1 cell.

[Trebor777]

Richard thanks, but there is no formula in A1, it is an input cell.

[Trebor777]

TRUE and FALSE

or

1 and 0

Deep respect, this works! I am surprised I couldn't find it on Mr Google. mega-thanks. K

[63falcondude]

Deep respect, this works! I am surprised I couldn't find it on Mr Google. mega-thanks. K

You're welcome. Glad to help.

[Richard Buttrey]

Richard thanks, but there is no formula in A1, it is an input cell.

In this forum when you haven't given a specific reference to a cell we tend to use A1 as a default. This is a fairly common practice.
So when you said 'I want a cell' without saying which it is then I used the general convention and used A1 as an example Since you're obviously talking about another cell then just substitute that one in my example.

I'm still somewhat puzzled though since just entering TRUE or FALSE in a cell is setting that cell as a Constant value. It will never change (unless of course you change it manually), so there seems little point in using it for testing with another cell.

[Trebor777]

Richard A1 is fine. The reason I want to enter a logical TRUE into a cell is complex. You may be amused by my next question which might help. Thanks