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."
Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
- Hot
- Latest
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Calculate a bonus in Microsoft Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Sum dollar amounts from a column in Micrsoft Excel
-
How To:
Find critical values with T functions in MS Excel
-
How To:
Calculate Commission Based on Varying Rates in Excel
-
How To:
Create a percentage frequency table in Microsoft Excel
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Extract part of a table from a larger table in Excel
-
How To:
Compare two lists and extract the new values in Excel
-
How To:
Calculate stock value based on the value of future dividend cash flow in Excel
-
How To:
Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
-
How To:
Solve for rate of change in Microsoft Excel
-
How To:
Archive data in Microsoft Access
-
How To:
Find a P-Value with Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Enter formulas in Excel with a macro
-
How To:
Conditionally format at every change in value in Excel
-
How To:
Use conditional formatting for a student grading report in Microsoft Excel
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Calculate a bonus in Microsoft Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Sum dollar amounts from a column in Micrsoft Excel
-
How To:
Find critical values with T functions in MS Excel
-
How To:
Calculate Commission Based on Varying Rates in Excel
-
How To:
Create a percentage frequency table in Microsoft Excel
-
How To:
Calculate proportions and percentages in Excel
-
How To:
Extract part of a table from a larger table in Excel
-
How To:
Compare two lists and extract the new values in Excel
-
How To:
Calculate stock value based on the value of future dividend cash flow in Excel
-
How To:
Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
-
How To:
Solve for rate of change in Microsoft Excel
-
How To:
Archive data in Microsoft Access
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