Learn some more advanced formula uses in Microsoft Excel including the "IF" statement. For example, "IF someone earned over $200 then charge them $20... otherwise charge them $40."
Just updated your iPhone? You'll find new emoji, enhanced security, podcast transcripts, Apple Cash virtual numbers, and other useful features. There are even new additions hidden within Safari. Find out what's new and changed on your iPhone with the iOS 17.4 update.
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Collaborate files between SharePoint and Office 2007
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Find a P-Value with Excel
How To:
Calculate vacation days with TODAY, YEAR & IF in Excel
How To:
Force text formulas to wrap with Excel's CHAR function
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Enter formulas in Excel with a macro
How To:
Put your MS Access databases on your website
How To:
Type a bomb symbol in Microsoft Word
How To:
Find the average time between orders in an Excel sheet
How To:
Fix a DGET #NUM! error in Microsoft Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Allow only Monday dates in a cell in Microsoft Excel
How To:
Find values with the INDEX & MATCH functions in Excel
How To:
Create a cumulative frequency distribution in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Collaborate files between SharePoint and Office 2007
How To:
Create a Tangent Line with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Find a P-Value with Excel
How To:
Calculate vacation days with TODAY, YEAR & IF in Excel
How To:
Force text formulas to wrap with Excel's CHAR function
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Enter formulas in Excel with a macro
How To:
Put your MS Access databases on your website
How To:
Type a bomb symbol in Microsoft Word
How To:
Fix a DGET #NUM! error in Microsoft Excel
How To:
Find the average time between orders in an Excel sheet
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Calculate leverage and solvency ratios in Microsoft Excel
How To:
Use the SERIES chart function in Microsoft Excel 2010
How To:
Encrypt emails with the Voltage Security Network Microsoft Outlook plug-in
1 Comment
I have this formula =AVERAGE(Sheet1!Z2:Z2356) but I need it to look at another cell for the month and use the if statement
Share Your Thoughts