Blog

How to use IF Formula for Multiple Conditions

How to use IF Formula for Multiple Conditions


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

Incentive Structure

Amount

Less Than 50

1000

51-60

1500

61-70

2000

71-80

2500

81-90

3000

91 and above

3500


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


Step-1

Step-2



Step-3


Step-4


For practicing this lesson, please  
CLICK HERE TO DOWNLOAD THE WORKBOOK

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.