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:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Compare two lists in Excel with match, join and filter
-
How To:
Cross tabulate categorical data in Microsoft Excel
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Calculate average and marginal tax rates in Microsoft Excel 2010
-
How To:
Create an Excel inventory template with running totals
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Insert, format, resize & crop pictures in MS Word
-
How To:
Graph the probability density function in an Excel file
-
How To:
Completely hide the Ribbon menu in Excel
-
How To:
Link two (multiple) workbooks & cells in Excel
-
How To:
Create a percentage frequency table in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Create a scatter diagram for 2 variables in Excel
-
How To:
Work with bank checks in Microsoft Excel
-
How To:
Create a stem & leaf chart with Excel's REPT & COUNTIF
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Compare two lists in Excel with match, join and filter
-
How To:
Cross tabulate categorical data in Microsoft Excel
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Calculate average and marginal tax rates in Microsoft Excel 2010
-
How To:
Create an Excel inventory template with running totals
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Insert, format, resize & crop pictures in MS Word
-
How To:
Graph the probability density function in an Excel file
-
How To:
Completely hide the Ribbon menu in Excel
-
How To:
Link two (multiple) workbooks & cells in Excel
-
How To:
Create a percentage frequency table in Microsoft Excel
-
How To:
Create a relative frequency distribution in MS Excel
-
How To:
Create a scatter diagram for 2 variables in Excel
-
How To:
Work with bank checks in Microsoft Excel
-
How To:
Create a stem & leaf chart with Excel's REPT & COUNTIF
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