Statement to be written in cell B10 :
IF ( B9 >= 470000, 35000, 1000)
Formula:
IF ( logical_test , [value_if_true] , [value_if_false] )
Explanation:
- logical_test = Net Profit After Tax (cell B9)
- value_if_true = 35000
<em>(if the Net Profit After Tax (cell B9) is greater than or equal to 47000 )</em>
<em> </em>3<em>.</em> value_if_false = 1000
<em>(if the Net Profit After Tax (cell B9) is lesser than 47000 )</em>
Each value should be separated by comma.
Answer:
2 (cooperation
)
3 (integrity)
5 (analytical thinking)
6 (dependability)
Explanation:
Good luck! Hope this helps.