answersLogoWhite

0


Best Answer

It is the result of the condition that can only be true or false. The condition itself is the test you are making to get a result so it could have things like equals, greater than, less than, not equal to, less than or equal to and greater than or equal to.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

Generally, yes. However, it depends on your definition, you also could evaluate as greater than (>) or less than (<). However, ultimately, you can break conditions down into a series of true or false responses.

This answer is:
User Avatar

User Avatar

Wiki User

7y ago

The result of evaluating a condition is always true or false.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Can a condition for a cell only be true or false in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Can the condition of a cell only be true using excel 2007?

No. The condition of a cell can be either true or false.


A condition of a cell can on only be true is that true or false?

The answeris true pg. # ex118


What is an condition for a cell can only be true or false?

There are several cases. Here are some common uses.IF([condition];"what to do if true";"what to do if false")OR([condition];"what to do if true";"what to do if false")AND([condition];"what to do if true";"what to do if false")In fact, the parameter [condition] is what can be true or false, it is a logical affirmation. For example:Is seven greater than two?The word "sun" has at least three letters?Is the word "Moon" identical to this word: "Moon" ?The above questions must be formulated in Excel language, referencing cells if necessary, and letting Excel to do the comparisons.Example: Let's assume that cell A2 has "7" in it, while B5 has "1"Is (number) greater than two?The following formula will return "Yes" (or any other message or calculation you need) with A2 but "No" with B5.IF( A2>2; "Yes" ; "No")The cell with the formula will display YesIF(B5>2;"Yes";"No")It will display NoYou can make formulas as complicated as you want.


Is it possible to choose formats that are applied only when a cell meets a specific condition?

Yes. There is a facility in Excel called Conditional Formatting that will allow you to do that.


Excel can display characters in only three font colors true or false?

False. You can choose from a range or colours to use for your fonts.


What is the maximum condition in a single excel 2003 cell can have?

In versions earlier than 2007 you can only have 3 conditions in one cell. You'll have to use VBA to go beyond those three.


The underline format will underline . in excel?

only the characters in the cell


The underline format will underline in excel?

only the characters in the cell


What will the underline format underline in excel?

only the characters in the cell


How do you use a if function in Excel on another cell with a nested if function?

i would need a little more information to be specific to your need, however the general way is =if(A1=2,"True value","False value",if(A1=3,"True Value","False Value)) you can continue the formula till you done with your conditions, however excel 2003 can only nest 7 level and Excel 2007 has no limits


What is inactive cell in excel?

At any one time you can only be working on one cell in Excel, like when you are typing data. Even if you have many cells selected, only one can actually be used. That cell is the active cell. All other cells are inactive. So an inactive cell is any cell that is not the active cell.


Is the fallowing sentences true or false the cell wall lies inside the cell membrane?

Well, the cell membrane is part of the cell. It's like a plastic wrap around the cell to keep it together. It is a thin shell only found on animal cells. Cell walls are like hard shells. These are only found on plant cells. So, its false.