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

Mathematics

Ellis Hahn

31 May, 20:26

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?

+5

Answers (1)

Know the Answer?

Jaydin Ramos · 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)