Dear Anaplanners: I have a question regarding usage of IF conditional statement. All the conditional constructs in Anaplan are related to IF with ELSE as a mandatory clause. However, I have following requirement - 1. I need to chnage the contents of cell A only when condition_A is satisfied. Otherwise, I do not want the contents to be changed at all. Above requirement can easily be satisfied if I have something like IF CONDITION_A THEN <> for the formula of cell A. But, I cant use IF without having ELSE. So, I tried - IF CONDITION_A THEN <> ELSE CELL_A for the forumla of cell A. But in this case, it is a circular reference and formula gets errored out. I am sure this is very common requirement, so not sure what I am missing...... Thanks! - Akshay Oak.
Solved! Go to Solution.