Excel VBA formulas for Spreadsheet by Sharath Kumar Peechara - HTML preview

/ Home / Technology / Excel VBA formulas for Spreadsheet

PLEASE NOTE: This is an HTML preview only and some elements such as links or page numbers may be incorrect.
Download the book in PDF, ePub, Kindle for a complete version.

Contents

Introduction

Exercise 1: IIF Function

Exercise 2: Custom Address Function

Exercise 3: Standard IF Function

Exercise 4: Specific IF Function

Exercise 5: IF,AND Function

Exercise 6: Multi OR Function

Exercise 7: Simple Multiplication

Exercise 8: Condensing HLOOKUP function

Exercise 9: Simplifying excel sheet Match function

Exercise 10: Rlookup (Right lookup) Function

Exercise 11: Simplified Vlookup formula version

Exercise 12: Choose Function

Exercise 13: Excel Run Time Version Function

Exercise 14: IsDate Function

Exercise 15: Auto recalculate

Exercise 16: Convert VBA Function to Excel Function

Exercise 17: National festive days Function

Exercise 18: Static Commission Function

Exercise 19: A Custom Function

Exercise 20: View the Formula of cell in another Cell

Exercise 21: Function with Case Insensitive

Exercise 22: Columnwidth function

Exercise 23: Rowheight function

Exercise 24: Monthname Function

Exercise 25: Space Function

Conclusion