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.
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.