How can I use the function of IF and ELSE in Excel to create a mechanism that can calculate the bonus for employees?

You can use the IF ELSE in Excel for the conditional statement for calculating the bonus based on the employees' performances. Here is the example scenario given:-

Let us consider that the performance of employees' score is in cell A1 and the bonus would be calculated in cell B1, then:-

  =IF(A1 > 90, “High Bonus”, IF(A1 >= 80, “Medium Bonus”, “No Bonus”))

In this above formula if the performance score in cell A1 is greater than 90, the employees would get a high bonus. If the score is between 80 to 90 then the employees would get a medium bonus. If the score is below 80 then the employees would not get any bonus.

You can also use the IF and ELSE functions in SQL for achieving this development of mechanism:-

SELECT 
    CASE 
        WHEN performance_score > 90 THEN ‘High Bonus’
        WHEN performance_score >= 80 THEN ‘Medium Bonus’
        ELSE ‘No Bonus’
    END AS bonus_category
FROM your_employee_table;