IF function is used to test a given condition i.e. true or false in Excel.If the condition holds true, the function returns a value as suggested by the user and if the condition holds false then also function returns a value.
Showing posts with label Functions. Show all posts
Showing posts with label Functions. Show all posts
Filter in MS Excel 2007
Filter in MS excel 2007 enables a user to have a compact and a more relevant view of the data. It allows a user to choose the desired data for analysis and hides data not required for current analysis.
Future Value in Excel 2007
Excel 2007 helps me estimate the amount I need to invest, in order to realize my dreams
Using SUMPRODUCT in MS EXCEL
Using SUMPRODUCT in MS EXCEL alternatively….
In my
previous post I took you through the basic use of SUMPRODUCT. In this post, I
will explain how to use SUMPRODUCT effectively and alternatively in MS EXCEL.
Using SUMPRODUCT in MS Excel effectively
Microsoft Excel is a magical platform made by Microsoft. But unfortunately many of us fail to harness its utility.
Today I am going to explain you how to use the SUMPRODUCT function of excel and reduce your precious time while working on MS Excel.
Subscribe to:
Posts (Atom)