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 Apple Intelligence capabilities, sudoku puzzles, Camera Control enhancements, volume control limits, layered Voice Memo recordings, and other useful features. Find out what's new and changed on your iPhone with the iOS 18.2 update.
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Tangent Line with Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Create a bond discount or premium amortization table in Excel
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Open, close & save documents in MS Word 2007
How To:
Do bank reconciliation in Microsoft Excel
How To:
Find a P-Value with Excel
How To:
Enter formulas in Excel with a macro
How To:
Use the Advanced Filter tool to extract data in Excel
How To:
Match text substrings with an array formula in Excel
How To:
Find 5 largest values with Excel's AGGREGATE function
How To:
Conditionally format at every change in value in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Tangent Line with Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Create a bond discount or premium amortization table in Excel
How To:
Create dynamic sub tables in Microsoft Excel
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Do bank reconciliation in Microsoft Excel
How To:
Open, close & save documents in MS Word 2007
How To:
Build a 15-minute schedule in Microsoft Excel
How To:
Find 5 largest values with Excel's AGGREGATE function
How To:
Enter formulas in Excel with a macro
How To:
Use the Advanced Filter tool to extract data in Excel
How To:
Match text substrings with an array formula in Excel
How To:
Find a P-Value with Excel
How To:
Conditionally format at every change in value in Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Hide scroll bars, sheet tabs & charts 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