Requirement: Employee Progress Increasing or not using IF function in Excel sheet
Create a Excel sheet, Provide three columns, Employee name, Employee Work Progress and Yes/ No. Calculating Work Progress and display Yes/ No according to their Percentage.
![](http://rishandigital.com/wp-content/uploads/2023/05/image-69.png)
Provide the equation to the Yes/No column
LOOKUP =IF(N6<.7 ,"No", "Yes")
![](http://rishandigital.com/wp-content/uploads/2023/05/image-70.png)
Using Lookup formula fill the entire Column
![](http://rishandigital.com/wp-content/uploads/2023/05/image-71.png)