A conditional formula always contains keyword "if". The output value is dependent on whether the condition defined in the if statement is met or not.
In the given statement If(A1>1,true,false), the Excel will check if A1 bigger than 1, it will result in true value otherwise false value. This is consider a simple example of conditional formula that only handles two conditions. In some complex cases that need to handle more than two conditions, we have to extend the formula with additional if statement.
