answersLogoWhite

0

Can true and false be summed with excel?

Updated: 8/17/2019
User Avatar

Wiki User

12y ago

Best Answer

Yes. TRUE has the value 1 and FALSE has the value of 0.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Can true and false be summed with excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

When you type numbers in a format that excel recognizes excel automatically applies format to the cell true or false?

False


How do you put an if statement in excel?

=IF(statement,true,false)


When using the AutoSum feature in Excel a suggestion of which values to use will appear true or false?

Yes, that is true. So for example, if it is at the bottom of a column of numbers, it will usually select those cells when the AutoSum is started. A user can still change the selection if they want different cells to be summed.


What category in Excel returns a true or false value?

Excel has a category called Logical Functions. The IF function is the one of those that most people use and associate with returning True or False values. Other functions also return True or False values. There is a TRUE function and a FALSE function. The OR function and the AND function can be used to return True or False values too. The NOT function can reverse a True or False value, so it also returns True or False.


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.


An Excel worksheet can contain up to 256 columns and 16384 rows. True or False?

True.


True or false can you add a maximum of 4 toolbars to a toolbar dock on excel 2003?

i think its false...


True or false does Excel treat any combination of numbers spaces and nonnumeric characters as numbers?

False.


What function in Excel deals with true or false?

The different functions from the Logical functions category deal with true and false. The main one of them is the IF function.


List the functions for the category 'Logical' in Microsoft Excel 2003?

A logical function is one that can return a true value or a false value. They are usually used in doing comparisons and seeing if things are equal to each other or not, or which is higher or lower. The logical functions that Excel provides are: TRUE FALSE AND OR NOT IF


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

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


When you magnify a worksheet excel enlarges the view of the characters on the screen and displays more rows and columns True or False?

False