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 100 if it is not

Answer:

Here is the formula:

=IF(B9>=470000, 35000, 100)

Explanation:

IF function can be used for this, the first parameter is the

condition to check.

B9>=470000, says that, if the value in cell B9 is greater

than or equal to 470000

Second parameter is the value that should be returned when this

condition becomes true, that is 35000 should be returned.

Third parameter is the value that should be returned when this

condition becomes false, that is 100 should be returned.

PLEASE UPVOTE IF YOU FOUND THIS HELPFUL!

PLEASE COMMENT IF YOU NEED ANY HELP!

|=F(@>>=470000, 35000, 100) IF(logical_test, [value_if_true], [value_if_false])

This post is last updated on hrtanswers.com at Date : 1st of September – 2022