Mr Excel & excelisfun Trick 136: Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP?

preview_player
Показать описание
Download Files:

See Mr Excel and excelisfun use two methods to calculate the total rent for a container based on a sliding scale:
1. VBA with Case
2. Nested IF function formula
3. VLOOKUP formula with three VLLOKUPs in one formula
4. VBA with simplier Case
  1. excelisfun
  2. Excel 2013
  3. Excel 2010
  4. Excel 2007
  5. Excel 2003
  6. excelisfun
Рекомендации по теме
Mr Excel & 0:14:25

Mr Excel & excelisfun Trick 185: Get Text Between First & Last Dash: 4 Methods

Mr Excel & 0:10:39

Mr Excel & excelisfun Trick 154: Totals by Product Code: Numbers & Code in Same Cell!?

Mr Excel & 0:08:23

Mr Excel & excelisfun Trick 176.5: Start and Min Times With Two Conditions / Criteria

Mr Excel & 0:09:22

Mr Excel & excelisfun Trick 120: Summarize By Week and Month, Monthly Totals, Weekly Totals

Mr Excel & 0:03:42

Mr Excel & excelisfun Trick 147: Avoid Sheet References From Current Sheet: View Or Arguments Di...

Mr Excel & 0:13:18

Mr Excel & excelisfun Trick 181: Month To Date: PivotTable or Excel Formulas?

Mr Excel & 0:09:47

Mr Excel & excelisfun Trick 171: Split First & Last Name Based on Second Capital Letter

Mr Excel & 0:09:06

Mr Excel & excelisfun Trick 189: VLOOKUP for Missing Values in Column

Mr Excel & 0:11:00

Mr Excel & excelisfun Trick 183: Lookup and Return Multiple Items And Join Them In Single Cell

Mr Excel & 0:12:23

Mr Excel & excelisfun Trick 186: Does Text Contain Number Digits? Flash Fill, Formula or VBA?

Mr Excel & 0:09:51

Mr Excel & excelisfun Trick 134: Merge Product and Sub-Product Text; VBA or Wild INDEX Formula

Mr Excel & 0:09:12

Mr Excel & excelisfun Trick 121: MIN and MAX Between Two Dates For Each Region

Mr Excel & 0:07:26

Mr Excel & excelisfun Trick 136: Variable Rent Calculation Based On Days: VBA, IF or VLOOKUP?

Mr Excel & 0:07:38

Mr Excel & excelisfun Trick 139: Formula To List Employees By Department

Mr Excel & 0:05:41

Mr Excel & excelisfun Trick 159: Three Way Lookup: SUMIFS or DGET?

Excelisfunner, Mr Excel 0:04:02

Excelisfunner, Mr Excel & excelisfun Trick 146: For Kids Multiplying In Excel Is Amazing!

Mr Excel & 0:05:32

Mr Excel & excelisfun Trick 175: Conditional Formatting to Highlight Cells with Formulas

Mr Excel & 0:05:58

Mr Excel & excelisfun Trick 177: Add Numbers That Are Missing From List

Mr Excel & 0:07:33

Mr Excel & excelisfun Trick 153: Show Day Numbers From Start & End Date: VBA or Formula?

Mr Excel & 0:08:01

Mr Excel & excelisfun Trick 126: SUM Daily Totals from Text Dates with Text Day Criteria

Mr Excel & 0:05:26

Mr Excel & excelisfun Trick 123: Lookup Column and then Add With Criteria

Mr Excel & 0:06:51

Mr Excel & excelisfun Trick 117: Extract Top Five Numbers

Mr Excel & 0:04:23

Mr Excel & excelisfun Trick 122: Entering Credit Card Numbers With More Than 15 Digits

Mr Excel & 0:14:48

Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description

Комментарии
Автор

Cool! I am give my points to Mr Excel!

excelisfun
Автор

The combination of Mike's logic in the last Custom Function created by MrExcel is beautyfull and simple and it is also a perfect example of how to use the "Case Select" statement !

ExcelStrategy