Hi, sorry, exhausted all searches. I want a formula to tell me if the IF function result is the true or the false result.

A very simple example, I have: =IF(1>0,(100*1),(100*2)), so I want another formula to tell me if my logical test was correct or not. I’m not interested in the answer of the IF formula itself, I want to know if the formula result is from the value_if_true or the value_if_false. In this example I want to know that my logical test was true.

By: Emma