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."
- Hot
- Latest
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Find a P-Value with Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Create a Tangent Line with Excel
-
How To:
Embed a YouTube video into PowerPoint w/ no internet
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Create an Excel inventory template with running totals
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Calculate a bonus in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Cross tabulate categorical data in Microsoft Excel
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Graph the probability density function in an Excel file
-
How To:
Print double-sided and reverse printing order in Word
-
How To:
Find the sample size for confidence intervals in Excel
-
How To:
Create a frequency distribution in Microsoft Excel
-
How To:
Use repeat (REPT) function in Excel
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Find a P-Value with Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Create a Tangent Line with Excel
-
How To:
Embed a YouTube video into PowerPoint w/ no internet
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Create an Excel inventory template with running totals
-
How To:
Clear data & cell contents in Excel using a macro
-
How To:
Calculate a bonus in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Cross tabulate categorical data in Microsoft Excel
-
How To:
Create a simple database in Excel with a list or table
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Graph the probability density function in an Excel file
-
How To:
Print double-sided and reverse printing order in Word
-
How To:
Find the sample size for confidence intervals in Excel
-
How To:
Create a frequency distribution in Microsoft Excel
-
How To:
Use repeat (REPT) function in Excel
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