Question

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.

Answer 1

Statement to be written in cell B10 :

IF ( B9 >= 470000, 35000, 1000)

Formula:

IF ( logical_test ,  [value_if_true] ,  [value_if_false] )

Explanation:

1. logical_test = Net Profit After Tax (cell B9)
2. value_if_true = 35000

(if the Net Profit After Tax (cell B9) is greater than or equal to 47000 )

    3. value_if_false = 1000

(if the Net Profit After Tax (cell B9) is lesser than 47000 )

Each value should be separated by comma.

Answer 2

The formula written to cell B10 is

IF (B9> = 470000, 35000, 1000)

IF (logical_test, [value_if_true], [value_if_false])

Further Explanation

The IF function is one of the most popular functions in Excel, which allows you to make logical comparisons between values ​​and estimates.

Therefore, IF statements can have two results. The first result if your comparison is True and the second result if the comparison is False.

For example, = IF (C2 = "Yes", 1,2) means IF (C2 = Yes, then give 1, if not give 2).

= IF (C2 = 1, "Yes", "No")

In this example, the formula in cell D2 says: IF (C2 = 1 then give Yes, if not give No) As you can see, the IF function can be used to evaluate text and values. The IF function can also be used to evaluate errors. You are not limited to only checking if one thing is the same as another and giving one result, you can also use a mathematical operator and do other calculations depending on your criteria. You can also stack multiple IF functions together to do multiple comparisons.

= IF (C2> B2, "Exceeding Budget", "In Budget")

In the example above, the IF function in D2 says IF (C2 Is Greater Than B2, returns "Exceeds Budget", if not returns "In Budget")

Learn More

IF in Excel https://brainly.com/question/11853071

The Formula https://brainly.com/question/11853071

Details

Class: High School

Subject: Computers and technology

Keyword: IF, excel, formula