Logo
programming4us
programming4us
programming4us
programming4us
Home
programming4us
XP
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Windows Phone
 
programming4us
Windows 7

Microsoft Excel 2010 : Building More Powerful Worksheets - Using Logical & Financial Functions

- How To Install Windows Server 2012 On VirtualBox
- How To Bypass Torrent Connection Blocking By Your ISP
- How To Install Actual Facebook App On Kindle Fire
8/9/2011 4:36:31 PM

Using Logical Functions

You can use logical functions to help you test whether conditions are true or false or make comparisons between expressions. The logical functions in Excel include: AND, FALSE, IF, IFERROR, NOT, OR, and TRUE. The structure of the IF function is IF(logical_test, value_if_false, value_if_false). For example, IF(E6<31,F6,””). If E6 is less than 31, then display the contents of F6; if not, then display nothing. You can also nest logical functions within a logical function. For example, IF(AND(E7>=61, E7<=90),F7,””). If E7 is greater than or equal to 61 and less than or equal to 61, then display the contents of F7; if not, then display nothing.

Use Logical Functions

Click the cell where you want to place the function.

Type = (equal sign), type a text function, specify the argument for the selected function, and then press Enter.

Some syntax examples include:

  • =IF(logical_test, value_if_false, value_if_false)

Some examples include:

  • =IF(E6<31,F6,””)

  • =IF(AND(E7>=61, E7<=90),F7,””)

  • =IF(NOT(A2<=15),“Goal”,“Not Goal”)

Or click the Formulas tab, click the Logical button, click a function, specify the function arguments, and then click OK.

Logical Functions

FunctionDescription
ANDReturns TRUE if all of its arguments are TRUE
FALSEReturns the logical value FALSE
IFSpecifies a logical test to perform
IFERRORReturns a value you specify if a formula evaluates to an error, otherwise returns the result of the formula
NOTReverses the logic of its argument
ORReturns TRUE if any argument is TRUE
TRUEReturns the logical value TRUE

Using Financial Functions

You can use financial functions to help you work with formulas related to business, accounting, and investment. You can use formulas for depreciation, such as SLN (Straight-Line Depreciation) and SYD (Sum-of-Years’ Digits), or formulas for interest and investments, such as FV (Future Value of an investment), EFFECT (Effective annual interest rate) or IPMT (Interest Payment for an investment or loan). Many of the investment functions use the following arguments: rate, nominal_rate, per, nper, pv, fv, pmt, and type. Rate is the interest rate per period; Nominal_rate is the nominal interest rate; Per is the period for which you want to find the interest (between 1 and nper); Nper is the total number of payments periods; Pv is the present value; Fv is the future value; Pmt is the payment made each period; and Type is the number 0 or 1 to indicate when payments are due (0 at the end of the period or 1 at the beginning of the period). Many of the depreciation functions use the following arguments: cost, salvage, and life. Cost is the initial cost of the asset; Salvage is the value at the end of the depreciation; Life is the number of periods the asset is depreciated.

Use Financial Functions

Click the cell where you want to place the function.

Type = (equal sign), type a text function, specify the argument for the selected function, and then press Enter.

Some syntax examples include:

  • =FV(rate, nper, pmt, pv, type)

  • =EFFECT(nominal_rate, npery)

  • =IPMT(rate, per, nper, pv, fv, type)

  • =SLN(cost, salvage, life)

  • =SYD(cost, salvage, life, per)

Or click the Formulas tab, click the Financial button, click a function, specify the function arguments, and then click OK.


Other -----------------
- Microsoft Excel 2010 : Building More Powerful Worksheets - Using Date & Time Functions
- Microsoft PowerPoint 2010 : Editing Comments in a Presentation
- Microsoft PowerPoint 2010 : Adding Comments to a Presentation
- Microsoft Visio 2010 : Creating New Shape Data Fields
- Microsoft Visio 2010 : Refreshing All Data in Linked Diagrams
- Microsoft Visio 2010 : Linking Diagrams to External Data
- Forwarding Events (part 2) - How to Troubleshoot Event Forwarding & How to Configure Event Forwarding in Workgroup Environments
- Forwarding Events (part 1) - How to Configure Event Forwarding in AD DS Domains
- Visual Basic 2010 : Platform Invokes and Interoperability with the COM Architecture - P/Invokes and Unmanaged Code
- Microsoft Visio 2010 : Changing Shape Data Attributes
 
 
Top 10
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 2) - Wireframes,Legends
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Finding containers and lists in Visio (part 1) - Swimlanes
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Formatting and sizing lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Adding shapes to lists
- Microsoft Visio 2013 : Adding Structure to Your Diagrams - Sizing containers
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 3) - The Other Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 2) - The Data Properties of a Control
- Microsoft Access 2010 : Control Properties and Why to Use Them (part 1) - The Format Properties of a Control
- Microsoft Access 2010 : Form Properties and Why Should You Use Them - Working with the Properties Window
- Microsoft Visio 2013 : Using the Organization Chart Wizard with new data
- First look: Apple Watch

- 3 Tips for Maintaining Your Cell Phone Battery (part 1)

- 3 Tips for Maintaining Your Cell Phone Battery (part 2)
programming4us programming4us
Popular tags
Microsoft Access Microsoft Excel Microsoft OneNote Microsoft PowerPoint Microsoft Project Microsoft Visio Microsoft Word Active Directory Biztalk Exchange Server Microsoft LynC Server Microsoft Dynamic Sharepoint Sql Server Windows Server 2008 Windows Server 2012 Windows 7 Windows 8 windows Phone 7 windows Phone 8
programming4us programming4us
 
programming4us
Natural Miscarriage
programming4us
Windows Vista
programming4us
Windows 7
programming4us
Windows Azure
programming4us
Windows Server
programming4us
Game Trailer