Analytics Khoj
  • Data Analysis
  • Web Data Analysis
  • Languages/Tools
    • Python
    • R-studio
    • Tableau
    • SQL Funda
    • Google Charts
  • Fundamental
    • Data Mining
    • Statistics
    • MS Word/Excel
    • Informative
  • Data Visualization
    • Google Charts
    • Tableau
    • Project World Stats
VLOOKUP help | Analytics Khoj

VLOOKUP help

How to calculate interest rates using VLOOKUP

Posted on July 5, 2015December 3, 2015 by Somenath

We have chart with four rows which actually giving interest rate for 1yrs, 5yrs, 10yrs and 30 yrs. Now from that chart our target is to find out interest rate for any year given as input. Here is the chart given as input. B and C columns hold the given year and corresponding interest rate.[…]

Posted in MS Word/Excel 3 Comments

Posts navigation

Recent Posts

  • Boruta Algorithm
  • Conditional Formatting in Tableau – II
  • Conditional Formatting in Tableau – I
  • Demonetization in India : Public Reaction Analysis
  • Descriptive Vs Inferential Statistics

Recent Comments

  • Rajashri Chakraborty on How to calculate interest rates using VLOOKUP
  • Ram on How to show columns forcefully which have blank (or NULL) value for a row in Tableau
  • Roma on How to show columns forcefully which have blank (or NULL) value for a row in Tableau
  • Irfan on How to show columns forcefully which have blank (or NULL) value for a row in Tableau
  • Manish on Practice R online interactively

Categories

  • Big Data
  • Data Analysis
  • Data Mining
  • Data Visualization
  • Google Charts
  • Informative
  • Languages/Tools
  • MS Word/Excel
  • Python
  • R-studio
  • Statistics
  • Tableau
  • Web Data Analysis
Kolkata
contact@site.com
Zerif Lite powered by WordPress
Zerif Lite powered by Analytics Khoj