Blog

IF Formula use for  Calculation in Multiple Conditions

Example

Now our accountant is in the problem of calculation of the incentive based on the incentive structure provided by the management based on the sales of the motorcycle, so here we can how the IF formula helps him

If Formulas based on the multiple conditions

Incentive Structure

Formula in common English.

If(Sales less than 51,Incentive will be 1000,if(Sales less than 61,Incentive will be 1500,if(Sales less than 71,incentive will be 2000,if (Sales less than 81,incentive will be 2500,if(Sales less than 90,incentive will be 3000,if(Sales greater than 91,incentive will be 3500)))))

Formula in excel terms

=IF(E12<51,$I$12,IF(E12<61,$I$13,IF(E12<71,$I$14,IF(E12<81,$I$15,IF(E12<=90,$I$16,IF(E12>90,$I$17))))))

Click Here for Detailed Lesson of PART-1 of IF FORMULA