0
For businesses, one thing that spreadsheets are often used for is forecasting or seeing what would happen in certain situations, often referred to as What-if analysis. Businesses need to know things like whether they have made a profit or not, and that may then decide as to what they can then do. If you make profits you can invest, but if you have not made a profit then you can't. Logical functions are based on conditions and seeing if a condition is true or false. So if it is true that you have made a profit, then you can invest. So to just simply see if you've made a profit, where your final balance is in cell D50, you could use and IF function like this:
=IF(D50>0,"Profit","Loss")
All that would do is print the word Profit or the word Loss, but in a more sophisticated spreadsheet you could replace those with some more complex action.
The IF function is the most commonly used logical function, but there are others that can be used enabling you to do much more complex things. You could make them decide on different actions depending on the amount of profit you make, or work out if you can afford to increase wages or start investing in new ranges or whether you could open a new premises.
There are so many things that you could do it is impossible to list them. Each kind of business will have its own requirements for them. In short, anywhere you need to make a decision based on some criteria or other, you can use logical functions.
Wiki User
∙ 11y ago
Add your answer:
Earn +20 pts
What are some logical Excel questoins?
In Excel logical data is usually derived from comparisons and determining conditions to see if the conditions fit or not. So for example you might want to see is one value greater than another or less than another or equal to another. Doing things like checking what is the correct rate of tax to deduct on a person's wage, depending on how much they earn would involve logical questions. There are a number of specialised functions provided by Excel for working with logical data and conditions. These are TRUE, FALSE, OR, AND, NOT and the most commonly used is IF. See the related question below for more information on the IF function.
What function calculates the budget on Excel?
The SUM function would be used to total up the figures for the budget, but other functions might be used too during the process.
Is the Range automatically selected by Excel always right?
No, the range automatically selected by Excel isn't always right. Excel doesn't know what the user wants to select, but chooses what might be appropriate, like the column of numbers above a SUM function. The user can go with what Excel has chosen, or choose their own cells.
Write an essay on Microsoft Excel?
Microsoft excel is a spreadsheet program developed by Microsoft corporation. There are different version of Microsoft excel with the latest being Microsoft excel 2010 which is boundled with Microsoft office 2010. Microsoft excel contains basic features of which all the spreadsheet programs have. It has worksheets which are a grid of cells. The grid of cell is arranged in rows and columns with the rows being referred to with numbers and rows with alphabetical letters. Microsoft excel has many wonderful features to offer the small business user. Excel is mosyt widely known for its spreadsheet function, though it has numerous other uses. Spreadsheets are useful to any type of small business. For example, spreadsheet can be used as an accountant's ledger or a professor's grade book. Invoices and budgets can be prepaired with excel and one might use it to balance a checkbook as well.
Is the uplookvert function used when the table direction is vertical or up?
Excel does not have an UPLOKVERT function. You might be thinking of VLOOKUP. You use VLOOKUP when your comparison values are located in a column to the left of the data that you want to find.
How do you enter formulae in Excel in lockup?
There is no function in Excel called LOCKUP. Please ask the question again after you have found the correct terminology or can provide more clarity to the question. Some options might be LOOKUP formula or how to enter formulas in cells that are protected.
In what area do you feel you excel and why?
There are a number of areas a person may feel that they excel in. Someone might feel that they excel in organization for example because they know where everything is.
How do you create an Excel to Oracle converter?
From MS Excel, there is nothing you can create. You can save an Excel file in various formats, that might make it easier to import the data into Oracle.
Can you make a logical guess how size might effect a nation's willingness to grant citizenship?
can you make a logical guess how size might affect a nation's willingness to grant citizenship
Give an example of a business office need that would benefit from the following Integrating Excel with Word?
The most obvious example would be embedding a piece of an Excel spreadsheet in a Word document, like a table or chart of sales figures or other data that might be put into a proposal or sales letter.
Will a judge use Microsoft Excel?
Some judges might.
How do you easily create Excel files in c?
You might be able to use C to extract data from an Excel file, but there is no easy way to write a program to create an Excel file.
