7 Replies Latest reply: Nov 27, 2018 9:11 AM by Rene Tan RSS

    Quiestion on formula for IF and And functions

    Rene Tan

      I am a new user of Monarch.  Is there a way create this excel formula "=IF(AND($G2>$AL$1|$AJ2="")|$AL$1-$R2|IF(AND($G2<$AL$1|$AJ2="")|$AL$1-$G2|IF($AJ2=""|$AL$1-$R2|0)))"  in Monarch?   Thank you