0
A logical function can in theory work with any kind of value. In the process it will have to get a boolean value, which is True or False, to perform the logic on. So it can do things like compare words or numbers or dates, which will result in a true or false value. These could be in cells referenced in the formula or as values in the formula. So you could have something like the ones that follow, each using the logical function IF:
=IF(A1>A2,"Higher","Lower")
=IF("Hello"="Hallo","Same","Different")
=IF(20>=50,"Bigger","Smaller")
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
What are logical functions?
A logical or boolean function is one that works with logical or boolean values - values that can only be either true, or false.
What is boolean function?
A boolean function is a function that only works with values that can only have two values, often called "true" and "false", or alternately, "1" and "0".
What are the function of MS Excel?
The main function of MS Excel is to simplify math and accounting functions and save time by putting everything in a spreadsheet. Excel can simplify payroll, track your financial income and outgo, and help you to create a budget that works for your situation.
Which formula can add the all the numeric values in a range of cells ignoring those which are not numeric and place the resulting a difference cell?
The alphanumeric values will already be ignored during a calculation in Excel sheet. So, any formula works. For example, if you got to take out the sum of cells A1 to F1, write =SUM(A1:F1).
Is Excel part of Works Suite 2005?
No, Excel is not part of the Works Suite 2005. It has its own spreadsheet in it and it is like Excel. It will do the vast majority of the things you would need to do.
Does Works Suite 2005 have Excel and PowerPoint?
No, it does not have Excel or Powerpoint. They are only in Office suites. Works does have a spreadsheet application, similar to Excel, though not as powerful. It would still do most of what a standard user would want to do. Works does not have a presentations package.
What are the different scientific values of a scientist?
a scientist must be : logical and systematic open-minded and free of bias intelectually honeswt works hard and persistent does not jump to conclucions creative long patience rational critical thinker curious about the world
Can you switch data from Works to Excel?
Yes, you can import MS Works data into MS Excel. thanks you can use two options first is paste and other one is paste special which is linked with excel with word.
What Scientific values?
logical and systematic open-minded and free of bias intelectually honeswt works hard and persistent does not jump to conclucions creative long patience rational critical thinker curious about the world by: jOjiE
When to use optional arguments in Excel?
Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.Optional arguments are ones in a function that you don't have to use. The function will still work without them. It will depend on the function you are using and what you are trying to achieve as to when you use them. Check the help on particular functions that have optional arguments and see what they do. Then experiment with them. They usually give extra information or change how the function works or include extra values. Sometimes you will be able to use them, and other times they are not necessary or a default value is taken.
If you prefer using the keyboard instead of the mouse you can press the alt key on in Excel?
Yes, the Alt key works in Excel.
Why does Microsoft Excel correctly calculate a running total for the first few cells and then stop giving incorrect values How can I change this Calculation is automatic.?
I set up function to give me a running total (or so I thought) that seems to work perfectly for the first few cells, but then suddenly stops working. It gives totally incorrect numbers that don't seem to come from anywhere. How can I fix this, clever people? This is my first time using Excel and I'm a little lost. As I say, the formula works perfectly for the first part. The calculation is, and has always been, set to automatic and I can't see an error in the function.
