Question

This is suppose to be a mathematical function I need to enter into excel. "Enter a formula in cell B10 to return a value of 35000 if the Net Profit after tax (Cell B9) is Greater than or equal to 470000 or 1000 if it is not." How do I type this out in excel using the IF function ?

Answer 1

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)