2 Replies Latest reply on Jun 8, 2012 9:04 AM by raybaudi

    AND OR nested formulas in calculation fields

    MikeF_1

      Title

      AND OR nested formulas in calculation fields

      Post

       

      Have the following formula in Excel that I need to duplicate in an FM calc field.

      I will wrestle around with the logistics, but can't seem to find any documentation on syntax for this type of formula.

      Can it be accomplished?

       

      =IF(OR(GC="",GC=0),"",IF(VP="Plus","",IF(AND(VP="VS",SR>GL),SR*AB15,"Less Than GC")))

       

      Thanks,

       - Mike