answersLogoWhite

0

One of the most useful functions in Excel is the IF function. What it does is test a value in a specific cell to see if that value meets a certain condition. If the value does meet the condition, one result will happen, if false, a different action will occur. Some people shy away from using this versatile function because of its apparent complexity. By doing this, they are missing out on one of the most useful functions available in Excel.

=IF(logical_test, value_if_true, value_if_false)

=IF(D1 < 26, 100, 200) Breaking the example down into its three parts we have: logical test: D1 < 26, ("<" means less than)

value if true: 100

value if false: 200

Breaking it down further, it basically says:

If Cell D1 is Less Than 26, Enter 100 in this cell, otherwise enter 200.

User Avatar

Wiki User

16y ago

What else can I help you with?

Related Questions

What functions can an accountant use in Excel?

There is a specialised category of Financial functions that an accountant could use, but they would use all sorts of different Excel functions besides the Financial functions. So regular ones like SUM and MAX and so on.


Why is there a need to know what functions are in creating formulas in Microsoft Excel?

Functions are basically built-in formulas in Excel. They are used extensively in Excel, so it is very important to know how to use them.


What does Excel use to separate multiple arguments in a function?

Commas are used to separate arguments in Excel functions.


MAX MIN COUNT and SUM are examples of what?

They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.They are all Excel functions and all come from the Statistical category of functions.


What are Microsoft Excel Add-ins?

They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.They provide different additional materials and functions for Excel to use. You can get extra statistical functions for example. There is no need to add them all, unless you are going to do much more sophisticated types of spreadsheets.


Is Excel a database file?

No. Excel is a spreadsheet package, not a file. You can use some basic database functions within Excel and you can also use Excel to store database information. However, in this respect, Excel is better for databases that are essentially flat files - Excel is not best suited for complex database structures.


How do you do advanced Excel functions?

There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.There is no simple answer to that. There are a huge range of functions in Excel, all with their own specific uses. So it would depend on what you want to do. To use some functions would require knowledge of other areas. Statisticians would have use for the more specialised statistical functions for example.


What tool can you use in Excel to automate time-consuming or tedious tasks?

Excel has many such tools, all fundamentally being formulas and functions.


What is the function of percentage in micro-soft Excel?

functions of excel


What is in an expression?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


What is an expression in excel?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.


How do you calculate degrees of freedom on excel?

Utilizing the visual basic functions built into excel worksheets you can calculate degrees of freedom. The function call that you use for this is "degrees_freedom".