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?

Question

Matthias Ramsey

Mathematics

17 July, 15:54

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?

+1

Answers (1)

Know the Answer?

Gunner Zimmerman · 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)