Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

Some functions in Excel are totally superior to other functions such as XNPV > NPV. Do you know of others?

There are a lot of stereotype questions on here so let’s up the level a bit. From my regular use of Excel I have come across functions that are totally superior to another function. Some of which are; XNPV Function is superior to the NPV Function. INDEX Function is superior to the OFFSET Function. Using INDEX and MATCH together to perform a lookup task is superior to using VLOOKUP, HLOOKUP, or LOOKUP. Which other Function do you think is superior to another?

user-image
Question ajoutée par Evans Otalor , Business Analyst / Facilitator , Marina Business School
Date de publication: 2013/05/04
Ahmad Hussam Malek
par Ahmad Hussam Malek , Deputy CEO , PMHC

XIRR Function is superior to the IRR Function.
other professional one is SUMPRODUCT which is superior to the SUMIF with only one condition

Andy Osaretin
par Andy Osaretin , Information Systems Database and Business Analyst Consultant , Alpha Consulting

Please explain using the INDEX/MATCH for performing lookup's

Hojimurod Bakirov
par Hojimurod Bakirov , Financial Projects Consultant , London School of Business & Finance

if you want to get an exact result from VLOOKUP (so in our case exact means FALSE and TRUE,s o we will not have any #N/A) it's better to combine vlookup with IF

Mike Emerson Pasaron
par Mike Emerson Pasaron , Safety Officer , Arabian Petrochemical Co. (PETROKEMYA)

in general array formulas are better than their volatile counterparts (index/match vs.
vlookup).
with regards to andy osaretin's question, =index(array,row_num,column_num) and match is =match(lookup_value,lookup_array,[match_type]).
Simplified version: =index(reference,in which row?,in which column?) and =match(what will i find?,reference,0=exact;1=greater than;-1=less than) In using index function, you need to know what is the row number and column number, this is where match function comes in especially if you are dealing with dynamic values.
hope it helps!

Mohamed Elkharashy
par Mohamed Elkharashy , Production Planning Engineer , Amiantit

GETPIVOTDATA

to retrieve summary data from a PivotTable report, provided the summary data is visible in the report.

JOVELYN MORA
par JOVELYN MORA , Technical Assistant , BROUQ TRADING

excel NPV function calculates the net present value of an investment, based on upplied discount rate, and a series of future payment and income.

RAHEL KORBU
par RAHEL KORBU , primily school , nafyad scool

to use subtraction, addition ,multiplication when we work easily to statically data

Muhammad Asif Jajja
par Muhammad Asif Jajja , Accountant , Pakistan Veterinary Medical Council

XIRR>IRR

Utilisateur supprimé
par Utilisateur supprimé

 

XIRR Function is superior to the IRR Function. other professional one is SUMPRODUCT which is superior to the SUMIF with only one condition

Utilisateur supprimé
par Utilisateur supprimé

The XIRR is better than the IRR

Kehinde Akinyemi
par Kehinde Akinyemi , kindergarten teacher , Knowledge school

Function is superior to the NPV function.

More Questions Like This