You work as a Sales Manager for Tech Perfect Inc. You are creating a report for your sales team using
Microsoft Excel. You want the report to appear in the following format:
You want the Remark column to be filled through a conditional formula. The criteria to give the
remark is as follows:
If the sales of the First Quarter is greater than or equal to 1200, display “Well Done”
If the sales of the First Quarter is lesser than 1200, display “Improve in Next Quarter”
You have done most of the entries in a workbook. You select the F2 cell as shown in the image given below:
Which of the following conditional formulas will you insert to accomplish the task?
A.
=IF(E2>1200,”Improve in Next Quarter”,”Well Done”)
B.
=IF(E2>=1200,”Well Done”,”Improve in Next Quarter”)
C.
=IF(E2>=1200,”Improve in Next Quarter”,”Well Done”)
D.
=IF(E2<=1200,”Well Done”,”Improve in Next Quarter”)
Explanation:
In order to accomplish the task, you will have to insert the following formula in the F2 cell:
=IF(E2>=1200,”Well Done”,”Improve in Next Quarter”)