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
Here is the formula:
=IF(B9>=470000, 35000, 100)
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