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 to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Make a gradebook based on percentage scores in Excel
How To:
Use advanced conditional formatting in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a Tangent Line with Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a bond discount or premium amortization table in Excel
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Find a P-Value with Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Create a table for the VLOOKUP function in Excel
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Add drawings and free-form shapes in MS Word 2007
How To:
Multiply column times row with Transpose in MS Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Do matrix multiplication and inverse in MS Excel
How To:
Make a gradebook based on percentage scores in Excel
How To:
Use advanced conditional formatting in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Create a Tangent Line with Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a bond discount or premium amortization table in Excel
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Use VLOOKUP across worksheets in MS Excel 2007
How To:
Find a P-Value with Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Create an Excel spreadsheet to calculate your GPA
How To:
Save Your Word Document as PDF with One Click (Using a Macro)
How To:
Insert and format a text box in Microsoft Word for Mac 2011
How To:
Create a table for the VLOOKUP function in Excel
How To:
Add drawings and free-form shapes in MS Word 2007
How To:
Create a dynamic weekly chart in Microsoft Excel
How To:
Work with math equations in Microsoft Excel 2010
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