Question

If A1=40 and B1=20 then the formula (A1 - B1)/2 returns:​

Answer 1

Answer:

For your Excel IF formula to display the logical values TRUE and FALSE when the specified condition is met and not met, respectively, type TRUE in the value_if_true argument. The value_if_false parameter can be FALSE or omitted. Here's a formula example:

=IF(B1>10, TRUE, FALSE)

or

=IF(B1>10, TRUE)

an example of the IF function that displays logical values TRUE or FALSE