The syntax for the IF statement is as follows:
=IF(condition, value if true, value if false)
therefore, we can enter the information from the problem:
=IF($B$9>=470000,35000,1000)
=IF(condition, value if true, value if false)
therefore, we can enter the information from the problem:
=IF($B$9>=470000,35000,1000)