Tag Archives: for

VBA – Excel If Function in VBA code

Excel If Function in VBA code. This VBA Function does exactly what the Excel If Function does. Code: Function ifCode(s1 As String, s2 As Variant, s3 As Variant) tst = Evaluate(s1) If tst = True Then ifCode = s2 Else … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , | Leave a comment

How to Use Criteria in Excel Filters and Functions

In this tutorial, I demonstrate how to use the “Logical Functions” of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Function, each logical test must answer TRUE. I frequently “Nest” the AND … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | 25 Comments

Excel 2010 Statistics 09: Proportions, Probabilities and Percentages: Formulas and Formatting

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Learn about Proportions, Probabilities and Percentages: Formulas and Formatting. 2. See the COUNTIF function and Relative and Absolute Cell References for counting with 1 criteria 3. See how to create a Basic Frequency Table with Qualitative … Continue reading

Posted in Learn Basic Excel | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 4 Comments

subtraction for children kindergarten Minus Basic first grade 1 2 3 4 5 6 7 8 9 10 flash card 0 12

Subtract formula in excel facts preschoolers math colors stoners song toddlers learn teach takeaway Babies adding rocks home school time table Duration : 0:1:21 Technorati Tags: Adding, addition, animation, babies, cards, children, Early, education, flash, for, indians, kids, kindergarteners, learn, … Continue reading

Posted in Learn Basic Excel | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , | Leave a comment

Excel Magic Trick # 264: Absolute & Relative Macro Fix Data

Learn How To Use A Macro With Relative and Absolute References to Deal With Data With Variable Row Size! A MUST TRICK IF YOU USE RECORDED MACROS. See how to use a recorded Macro to take a data set and … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , | 6 Comments

Office 2010 Class #30: Excel Date Formulas: Days Invoice Past Due, Loan Maturity Date, Project Days

Download files at: https://people.highline.edu/mgirvin/AllClasses/216_2003/216/busn216.htm The Excel 2010 Basics Series shows a systematic description of what Excel can do from beginning to end. Topics Covered In Video: 1. Date Number Format (Serial Numbers) 2. Date Math 3. Formula for Days Invoice … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 6 Comments

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like “Monday” 3. TEXT Function to get Month spelled out, like “January” 4. MONTH Function 5. YEAR function 6. Last Day in Month: EOMONTH function 7. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 2 Comments

Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Create Logical Formula for Conditional Formatting to highlight the lowest smallest value in the row using the MIN function and Mixed Cell References. 2. Create Logical Formula for Conditional Formatting to highlight the largest biggest value … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 2 Comments

Excel – Formulas for Percentage

Excel – Formulas for Percentage Duration : 0:4:21 Technorati Tags: attendance, excel, for, formulas, how to, percentage, software, technology, tutorial

Posted in Learn Excel Formulas | Tagged , , , , , , , , | Leave a comment