Search

IFS & IF


IF forumla allows for a custom outcomes depending if the statement is TRUE or FALSE.


logical_test:


Evaluates a statement that either TRUE or FALSE


[value_if_true]:


formula or value if statement is TRUE


[value_if_false]:


formula or value if statement is FALSE


IFS formula allows to to evaluate multiple statements and create a custom outcome for each statement that is evaluates.


logical_test1:


Evaluates a statement.


value_if_true1:


formula of value if logical_test1 is TRUE.


4 views