IF Function is used when we have to perform a logical test on a particular condition. Let us see how to use IF Function in MS Excel (R)

If a project cost is estimated to be $1000 for the next 5 years, then if the budget allocation for $800, $1100, $1300, $750 and $ 1000 for next 5 years, then the deficit is to be calculated for every year as below.