Short Answer 
The answer explains how to use the IF function in Excel, starting with understanding its structure, defining a logical test based on the Net Profit After Tax in cell B9, and determining the outputs for true (35,000) and false (1,000) scenarios. The final formula is IF(B9 >= 470000, 35000, 1000).
Step 1: Understand the Function Structure
The formula you’re using is the IF function in Excel, which analyzes a specified condition. It follows a structure where you provide a logical test, a value if the test is true, and a value if it’s false. This allows you to make decisions based on certain criteria.
Step 2: Define the Logical Test
In your case, the logical test is represented by cell B9, which shows the Net Profit After Tax. The expression checks if this value is greater than or equal to 470000. This sets the stage for the function to evaluate whether to return the true or false result.
Step 3: Set Values for True and False Outcomes
Based on the logical test outcome, you will determine what value to display in cell B10. If B9 is greater than or equal to 470000, the function will return 35000. If it is less than 470000, it will return 1000. Thus, the final formulation in cell B10 will be:
- Formula: IF(B9 >= 470000, 35000, 1000)
- Value if true: 35000
- Value if false: 1000